从存储过程Transact-SQL SQL Server中访问结果集

CREATE PROCEDURE GetResults
AS
BEGIN
    DECLARE @Results TABLE(
        ID INT,
        Name NVARCHAR(50)
    )

    INSERT INTO @Results
    SELECT ID, Name FROM SomeTable

    SELECT * FROM @Results
END

CREATE PROCEDURE GetResults
AS
BEGIN
    DECLARE @ID INT
    DECLARE @Name NVARCHAR(50)

    DECLARE CursorName CURSOR FOR
    SELECT ID, Name FROM SomeTable

    OPEN CursorName
    FETCH NEXT FROM CursorName INTO @ID, @Name

    WHILE @@FETCH_STATUS = 0
    BEGIN
        -- Do something with @ID and @Name

        FETCH NEXT FROM CursorName INTO @ID, @Name
    END

    CLOSE CursorName
    DEALLOCATE CursorName
END