和表一样的 declare @tb table(CustNo char(10))
insert into @tb select CustNo from Con_004
...........
declare cursor_insert cursor for select * from @tb
declare @i int
open cursor_insert
fetch cursor_insert into @i
while @@fetch_status=0
begin
print @i
fetch cursor_insert into @i
end
close cursor_insert
deallocate cursor_insert
insert into @tb select CustNo from Con_004
...........
declare cursor_insert cursor for select * from @tb
declare @i int
open cursor_insert
fetch cursor_insert into @i
while @@fetch_status=0
begin
print @i
fetch cursor_insert into @i
end
close cursor_insert
deallocate cursor_insert
看来是无法替代的吧..?我想应该理解为尽量用集合的操作代替单记录集的操作,所以没错。用 Table 取代游标的方法是 JOIN
不对。不同的概念和用法。