sqlserver游标小实例循环列表

USE [Area]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[ProcTest]
    @ROut INT OUTPUT
AS
    SET @ROut = 0
BEGIN       
    BEGIN TRAN
    BEGIN TRY  
        DECLARE @Id int
        DECLARE @Name varchar(100)
        DECLARE CursorCP CURSOR  FOR --声明外层游标
        select Id,Name from dbo.test 
        OPEN CursorCP --声明外层游标
        FETCH NEXT FROM CursorCP into @Id,@Name --提取外层游标行
        WHILE @@fetch_status<>-1
        BEGIN

           --执行操作

           insert into dbo.test(Pid,name)values(2,'aaaa')
           SET @ROut = 1    
           FETCH NEXT FROM CursorCP into @Id,@Name
        END  
         CLOSE CursorCP
         DEALLOCATE CursorCP        
        COMMIT TRAN
    END TRY
    BEGIN CATCH
        ROLLBACK TRAN
    END CATCH
END