如何使用游标？

一般教程都有讲到.

declare @data varchar(30)
declare rs_cursor cursor for select ShipAddress from Orders
open rs_cursor
fetch rs_cursor into @data
while @@fetch_status=0
begin
print @data
fetch rs_cursor into @data
end
close rs_cursor
deallocate rs_cursor