13db.txt

来自「the original code of the book the princi」· 文本 代码 · 共 41 行

--use 企业销售管理系统

/*标准游标*/
--declare hycursorzf1 cursor for
--  select * from 职工 where 工资 between 1000 and 2000
/*只读游标*/
--declare hycursorzf2 cursor for
-- select * from 职工 where 工资>1200
-- for read only

/*更新游标*/
--declare hycursorzf3 cursor for
--select * from 职工 where 仓库号!='wh1'
--for update
-- hycursorzf3 


declare hycursorzf4 scroll cursor for
select * from 供应商
open hycursorzf4 
fetch first from hycursorzf4
fetch next from hycursorzf4
fetch last from hycursorzf4
fetch prior from hycursorzf4
fetch absolute 2 from hycursorzf4
fetch relative 2 from hycursorzf4
close hycursorzf4
deallocate hycursorzf4


use 企业销售管理系统
declare hycursorzf5 scroll cursor for
select 职工号,姓名,工资 from 职工
declare @t varchar(10)
declare @t1 varchar(10)
declare @t2 int
open hycursorzf5
fetch absolute 4 from hycursorzf5 into @t,@t1,@t2
select @t as 职工号,@t1 as 职工名,@t2 as 工资
close hycursorzf5
deallocate hycursorzf5