天天看點

Sqlserver 遊标的例子

declare T_cursor cursor for select PhoneNo from PhoneDetail order by phoneno

open T_cursor

fetch next from T_cursor into @PhoneNo

while @@fetch_status=0 

begin  

fetch next from T_cursor into @PhoneNo

end 

close T_cursor 

deallocate T_cursor

繼續閱讀