[导入]游标循环读取数据

declare @ssid nvarchar(50)
declare cur cursor
read_only
for select top 1 ssid from ssidinfo
open cur

fetch next from cur into @ssid
while (@@fetch_status =0)
begin
print @ssid
fetch next from cur into @ssid
end
close cur
deallocate cur

阅读全文
类别：Sqlserver 查看评论
文章来源:http://hi.baidu.com/zzticzh/blog/item/c43cb9b7b3fe63f530add178.html