数据库游标的使用

最新推荐文章于 2025-09-08 20:55:49 发布

hebeijg

最新推荐文章于 2025-09-08 20:55:49 发布

阅读量399

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

本文链接：https://blog.youkuaiyun.com/hebeijg/article/details/5792721

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