游标使用的简单示例
SELECT * FROM aspnet_Roles GO DECLARE @role varchar(50) DECLARE CusCursor CURSOR FOR select RoleName from aspnet_Roles OPEN CusCursor FETCH NEXT FROM CusCursor INTO @role WHILE (@@FETCH_STATUS = 0) BEGIN SELECT @role --这里写SQL语句 FETCH NEXT FROM CusCursor INTO @role END CLOSE CusCursor DEALLOCATE CusCursor
如图所示:
本文来自博客园,作者:VipSoft 转载请注明原文链接:https://www.cnblogs.com/vipsoft/p/3569580.html