【SQL开源代码栏目提醒】:网学会员--在 SQL开源代码编辑为广大网友搜集整理了:实例334应用游标的嵌套查询两个员工表间员工信息.sql绩等信息,祝愿广大网友取得需要的信息,参考学习。
USE db_
sql2000
GO
declare @name varchar(10) /*声明变量*/
declare cur_lab cursor for /*声明游标*/
select from tb_laborage13 where 员工编号 =1001 /*定义游标结果集*/
open cur_lab /*打开游标*/
fetch next from cur_lab into @name /*将变量赋值*/
while ( @@fetch_status=0 )
begin
declare @day varchar(10) /*声明变量*/
declare cur_lab_2 cursor for /*声明游标*/
select 请假天数 from tb_job18 where = @name /*定义结果集*/
open cur_lab_2 /*打开游标*/
fetch next from cur_lab_2 into @day /*使用游标将变量赋值*/
while ( @@fetch_status=0)
begin
print '编号为1001的员工的请假天数为' +@day +'天' /*输出编号为1的请假天数*/
return
end
close cur_lab_2 /*关闭游标*/
deallocate cur_lab_2 /*释放游标*/
end
close cur_lab
deallocate cur_lab