--错在这儿
DECLARE Employee_Cursor CURSOR FOR
exec bbb @abb=48----------- 定义游标结果集要用标准 SELECT 语句
可以先执行bbb过程返回的结果集插到一张临时表后在定义cursor
Insert into #tab
exec bbb 88
DECLARE Employee_Cursor CURSOR FOR
exec bbb @abb=48----------- 定义游标结果集要用标准 SELECT 语句
可以先执行bbb过程返回的结果集插到一张临时表后在定义cursor
Insert into #tab
exec bbb 88
as
DECLARE Employee_Cursor CURSOR FOR
exec bbb @abb=48--------------------------------错的!看看SQL帮助吧。
OPEN Employee_Cursor
FETCH NEXT FROM Employee_Cursor
WHILE @@FETCH_STATUS = 0
BEGIN
FETCH NEXT FROM Employee_Cursor
END
CLOSE Employee_Cursor
DEALLOCATE Employee_Cursor
GO
------------------------
insert @t1 select grp.id,grp.pid,@T_levn from grp where grp.id=@abb
while @@rowcount>0-----那个表?
begin
set @T_levn=@T_levn+1
insert @t1 select grp.id,grp.pid,@T_levn from grp where grp.pid in (select id from @t1 where T_levn=@T_levn-1)
end