一个简单的Sybase游标
DECLARE cursor_a CURSOR --声明游标FOR SELECT name FROM cc_tb_cfg_operator WHERE oper_id > 0--order by sDomainCodego--缺少go将报错：DECLARE CURSOR must be the only statement in a query batchOPEN cursor_a --打开游标DECLARE @domainCode VARCHAR(11), @message VARCHAR(80)FETCH cursor_a INTO @domainCode --提取游标数据WHILE @@sqlstatus = 0 BEGIN --PRINT " " --SELECT @message = "----- Books by Author: " + @domainCode --PRINT @message --to do something..... -- Get the next cur. FETCH cursor_a INTO @domainCode ENDCLOSE cursor_aDEALLOCATE CURSOR cursor_a --删除游标
页:
[1]