完整语句如下:ALTER procedure bicbom (@Number varchar(40)) as
declare @FNumber varchar(40),@FNo int select * into #_group from ICBomGroup --写入临时表后写游标 declare Cur_inventory cursor for select FName,fbootid from #_group where fparentid=0 open Cur_inventory FETCH NEXT FROM Cur_inventory INTO @fnumber,@fno WHILE @@FETCH_STATUS = 0 --当前存取成功 BEGIN -- UPDATE #_group SET fnumber=@fnumber WHERE fbootid=@fno FETCH NEXT FROM Cur_inventory INTO @fnumber,@fno END CLOSE Cur_inventory DEALLOCATE Cur_inventory select a.fbomnumber,b.fname from icbom a left join #_group b on b.finterid=a.fparentid where number=@number order by a.fbomnumber
as
declare @FNumber varchar(40),@FNo int
select * into #_group from ICBomGroup --写入临时表后写游标
declare Cur_inventory cursor for select FName,fbootid from #_group where fparentid=0
open Cur_inventory
FETCH NEXT FROM Cur_inventory
INTO @fnumber,@fno
WHILE @@FETCH_STATUS = 0 --当前存取成功
BEGIN
--
UPDATE #_group SET fnumber=@fnumber WHERE fbootid=@fno
FETCH NEXT FROM Cur_inventory
INTO @fnumber,@fno
END
CLOSE Cur_inventory
DEALLOCATE Cur_inventory select a.fbomnumber,b.fname from icbom a left join #_group b on b.finterid=a.fparentid where number=@number order by a.fbomnumber
谢谢 chuifengde 谢谢大家