sybase和mssqlserver游标的写法区别

sybase游标写法：

declare cursor_name cursor for select * from table
open cursor_name

fetch cursor_name into 变量

while @@sqlstatus=0
begin

???? 处理数据...

???? fetch cursor_name into 变量

end
close cursor_name

deallocate cursor cursor_name

mssqlserver游标写法：

declare cursor_name cursor for select * from table
open cursor_name

fetch next cursor_name into 变量

while @@fetch_status = 0
begin

???? 处理数据...

fetch next cursor_name into 变量

end
close cursor_name

deallocate cursor cursor_name

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!