数据库游标的使用

declare @UserId int
declare @Realname nvarchar(50)
declare test cursor  for select UserId,RealName from UserTest
open test
    fetch next from test into @UserId,@RealName
    while @@fetch_status=0
    begin
        print 'UserId:'+str(@UserId) +',RealName:'+@RealName

        fetch next from test into @UserId,@RealName
    end
close test
deallocate test