sql2005 返回游标参数的存储过程 【CURSOR VARYING OUTPUT】

参考：http://technet.microsoft.com/zh-tw/library/ms175498(SQL.90).aspx

         http://msdn.microsoft.com/zh-cn/ms173806(SQL.90).aspx

 

1.返回游标 的存储过程

 

USE AdventureWorks; GO IF OBJECT_ID ( 'dbo.uspCurrencyCursor', 'P' ) IS NOT NULL DROP PROCEDURE dbo.uspCurrencyCursor; GO CREATE PROCEDURE dbo.uspCurrencyCursor @CurrencyCursor CURSOR VARYING OUTPUT AS SET NOCOUNT ON; SET @CurrencyCursor = CURSOR FORWARD_ONLY STATIC FOR SELECT CurrencyCode, Name FROM Sales.Currency; OPEN @CurrencyCursor; GO

 

2.调用含有游标参数的 存储过程

 

USE AdventureWorks; GO DECLARE @MyCursor CURSOR; EXEC dbo.uspCurrencyCursor @CurrencyCursor = @MyCursor OUTPUT; FETCH NEXT FROM @MyCursor; WHILE (@@FETCH_STATUS = 0) BEGIN; FETCH NEXT FROM @MyCursor; END; CLOSE @MyCursor; DEALLOCATE @MyCursor; GO