?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 （釋放）

總結

以上是生活随笔為你收集整理的sybase游标使用方法的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。