34,590
社区成员
发帖
与我相关
我的任务
分享
declare cursor_tb cursor for
select id ,name FROM tb
declare @name varchar(10),@con int
open cursor_tb
IF CURSOR_STATUS('global','cursor_tb')> 0
print '呵呵'
else
print '西西'
close cursor_tb
deallocate cursor_tb
declare cursor_tb cursor local for
select id ,name FROM tb
declare @name varchar(10),@con int
open cursor_tb
IF CURSOR_STATUS('local','cursor_tb')> 0
print '呵呵'
else
print '西西'
close cursor_tb
deallocate cursor_tb
--声明一个游标mycursor,select语句中参数的个数必须要和从游标取出的变量名相同
declare mycursor cursor for select emp_cd,emp_name from m_employee
======〉
--声明一个游标mycursor,select语句中参数的个数必须要和从游标取出的变量名相同
declare mycursor cursor local for select emp_cd,emp_name from m_employee