declare @Id int
declare item_cursor cursor local for SELECT A.Id FROM A
open item_cursor
FETCH NEXT FROM item_cursor INTO @Id
while @@FETCH_STATUS = 0
begin
....................................
FETCH NEXT FROM item_cursor INTO @Id
end
close item_cursor
deallocate item_cursor --一定得记得在关闭之后要释放游标
declare item_cursor cursor local for SELECT A.Id FROM A
open item_cursor
FETCH NEXT FROM item_cursor INTO @Id
while @@FETCH_STATUS = 0
begin
....................................
FETCH NEXT FROM item_cursor INTO @Id
end
close item_cursor
deallocate item_cursor --一定得记得在关闭之后要释放游标