--定义变量
DECLARE @UserID INT
--定义游标
DECLARE cur_userId CURSOR FAST_FORWARD READ_ONLY FOR
SELECT distinct FUserID FROM t_User ORDER BY FUserID ASC
-- 打开游标
OPEN cur_userId
FETCH NEXT FROM cur_userId INTO @UserID
-- 循环
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT @UserID
FETCH NEXT FROM cur_userId INTO @UserID
END
--关闭游标
CLOSE cur_userId
DEALLOCATE cur_userId
游标与While循环的使用
最新推荐文章于 2023-04-16 14:33:53 发布