如何在Server 2008中执行具有游标的过程？

Question

我知道如何在SQL Server2008中执行存储过程，但对于执行包含游标的存储过程，我却一无所知。

我的代码：

 BEGIN TRANSACTION 
 GO

DROP PROCEDURE SampleProcedure
GO

CREATE PROCEDURE SampleProcedure 
AS 
    DECLARE @FirstName varchar(64)

    DECLARE c1 CURSOR READ_ONLY
    FOR
        SELECT FIRST_NAME
        FROM EMPLOYEE

    OPEN c1

    FETCH NEXT FROM c1 INTO @FirstName

    WHILE @@FETCH_STATUS = 0
    BEGIN
        PRINT @FirstName

        FETCH NEXT FROM c1 INTO @FirstName
    END

    CLOSE c1
    DEALLOCATE c1

    COMMIT TRANSACTION 

我见过在Oracle中使用游标执行过程，但在Server中找不到。请告诉我如何执行包含游标的存储过程。

-谢谢

Answer 1

执行SP。

EXEC SampleProcedure