游标变量用法经典

-- -生成测试表T
if   exists ( select   1   from  sysobjects  where  Name = N ' T '   and   objectProperty (ID,N ' IsUserTable ' ) = 1 )
     drop   table  T
go
select   top   5  ID,Name  into  T  from  sysobjects
go
方法1:

-- 创建输出游标变量的存储过程:

create   procedure  P_cursor(
                             @Roy_Test   cursor   varying  output
                        )
as

set   @Roy_Test = cursor  global  for
select  
    ID,Name
from  
    T
open   @Roy_Test