新增文章

文章标题分类内容

-------------------------------------------------------------------------------------
-- 定义变量

DECLARE @UserId varchar(100),@username varchar(20)

-------------------------------------------------------------------------------------
-- 定义游标

DECLARE cursor1 CURSOR  
   FOR
   SELECT TOP 10 UserId,UserName FROM UserInfo ORDER BY UserId DESC  -- 数据来源

-------------------------------------------------------------------------------------
-- 打开游标 读取数据

OPEN cursor1                                      -- 打开游标
   FETCH NEXT FROM cursor1 INTO  @UserId,@username   -- 抓取数据

-------------------------------------------------------------------------------------
-- 数据处理

WHILE @@FETCH_STATUS = 0
   BEGIN
     PRINT '用户ID：'+@UserId+'            '+'用户名：'+@username
     
            if @UserId = 0 begin
            
               break;  -- 跳出游标
            end

FETCH NEXT FROM cursor1 INTO @UserId,@username
   END

-------------------------------------------------------------------------------------
-- 关闭游标

CLOSE      cursor1  -- 关闭游标
   DEALLOCATE cursor1  -- 释放游标