proceduredemo19.sql

T-SQL示例大全

/* 文件名称: ProcedureDemo19.sql */
USE 北风贸易
GO

-- 声明一个 cursor 数据类型的局部变量 @TakeCursor
-- 以便接收存储过程所返回的数据指针(cursor)
DECLARE @TakeCursor CURSOR

DECLARE @department nvarchar(10)
DECLARE @address nvarchar(41)

SET @department = N'生产制造部'
SET @address = N'%北京市%'

--执行存储过程 fox_cursor_proc 并接收所返回的数据指针(cursor)
EXEC fox_cursor_proc @department,@address,@TakeCursor OUTPUT

FETCH FIRST FROM @TakeCursor

WHILE (@@FETCH_STATUS = 0)
  BEGIN
     FETCH NEXT FROM @TakeCursor
  END

CLOSE @TakeCursor
DEALLOCATE @TakeCursor

GO