http://www.itkee.com/database/detail-792.html
Sybase 游标使用例子
---游标使用 (游标名字为appeal_num_cursor)
DECLARE @serial_112 int, @dir_num char(15), @complaint_time datetime
--申明一个游标
DECLARE appeal_num_cursor CURSOR
FOR SELECT serial_112,dir_num,complaint_time FROM #iptv_guang order by dir_num,complaint_time
--打开一个游标
OPEN appeal_num_cursor
--循环一个游标
FETCH /*NEXT FROM*/ appeal_num_cursor INTO @serial_112,@dir_num,@complaint_time
WHILE @@SQLSTATUS = 0 -- @@FETCH_STATUS = 0 --
BEGIN
declare @c_num int,@appeal_num int
select @c_num = appeal_num from #iptv_guang where dir_num = @dir_num
if @c_num = 0
begin
select @appeal_num = 1
end
else begin
select @appeal_num = @c_num + 1
end
update #iptv_guang
set appeal_num = @appeal_num
where dir_num = @dir_num and
complaint_time = @complaint_time and
serial_112 = @serial_112
FETCH /*NEXT FROM*/ appeal_num_cursor INTO @serial_112, @dir_num,@complaint_time
END
--关闭游标
CLOSE appeal_num_cursor
--释放资源
DEALLOCATE cursor appeal_num_cursor
================
http://www.ixpub.net/thread-2561277-1-1.html
sybase游标使用方法1、DECLARE CUR_ACCTINFO CURSOR FOR SELECT ..... (定义)
2、OPEN CUR_ACCTINFO (打开)
3、WHILE @@SQLSTATUS = 0 (判断是否成功)
BEGIN
4、 FETCH CUR_ACCTINFO INTO ....... (取数据)
IF @@SQLSTATUS ; 0
begin
......
end
...........
5、CLOSE CUR_ACCTINFO (关闭)
6、DEALLOCATE CURSOR CUR_ACCTINFO (释放)