Question

sqlserver 如何循环获得结果集中的数据，每次获得一条

我有10条数据，每次循环需要获得一条数据，把该数据赋值到变量中去

Answer 1

游标循环
declare @id varchar(20)
declare MyCur cursor for select id from table
open mycur
fetch next from mycur into @id
while @@fetch_status=0
begin
--自己处理的过程

fetch next from mycur into @id
end
close mycur

Answer 2

Do While Not rs.EOF
rs.MoveNext
loop