关闭

SQL游标操作

标签: sqlinserttable
1709人阅读 评论(0) 收藏 举报
分类:

select count(id) from info

select * from info

--清除所有记录
truncate table info

declare @i int
set @i=1
while @i<1000000
begin
 insert into info values('Justin'+str(@i),'深圳'+str(@i))
 set @i=@i+1
end


--声明游标
declare my_cursor cursor keyset for select * from info
--删除游标资源
deallocate my_cursor

--打开游标,在游标关闭或删除前都有效
open my_cursor
--关闭游标
close my_cursor

--声明局部变量
declare @id int,@name varchar(20),@address varchar(20)
--定位到指定位置的记录
fetch absolute 56488 from my_cursor into @id,@name,@address
select @id as id,@name as name,@address as address
--定位到当前记录相对位置记录
fetch relative -88 from my_cursor into @id,@name,@address
select @id as id,@name as name,@address as address
--定位到当前记录前一条
fetch prior from my_cursor into @id,@name,@address
select @id as id,@name as name,@address as address
--定位到当前记录后一条
fetch next from my_cursor into @id,@name,@address
select @id as id,@name as name,@address as address
--定位到首记录
fetch first from my_cursor into @id,@name,@address
select @id as id,@name as name,@address as address
--定位到尾记录
fetch last from my_cursor into @id,@name,@address
select @id as id,@name as name,@address as address

0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:109873次
    • 积分:1794
    • 等级:
    • 排名:千里之外
    • 原创:63篇
    • 转载:19篇
    • 译文:0篇
    • 评论:17条
    最新评论
    JAVA语言相关
    我喜欢的网站