declare orderNum_03_cursor cursor scroll
for select OrderId ,userId from bigorder where orderNum='ZEORD003402'
2.打開游標
open orderNum_03_cursor
3.聲明游標提取數(shù)據(jù)所要存放的變量
declare @OrderId int ,@userId varchar(15)
4.定位游標到哪一行
fetch First from orderNum_03_cursor into @OrderId,@userId --into的變量數(shù)量必須與游標查詢結(jié)果集的列數(shù)相同
while @@fetch_status=0 --提取成功必怜，進行下一條數(shù)據(jù)的提取操作
begin
if @OrderId=122182
begin
Update bigorder Set UserId='123' Where Current of orderNum_03_cursor --修改當前行
end
if @OrderId=154074
begin
Delete bigorder Where Current of orderNum_03_cursor --刪除當前行
end
fetch next from orderNum_03_cursor into @OrderId ,@userId --移動游標
end
5.關(guān)閉游標語法
close [ Global ] cursor_name | cursor_variable_name
--關(guān)閉游標
close orderNum_03_cursor
6.釋放游標語法
deallocate [ Global ] cursor_name | cursor_variable_name
--釋放游標
deallocate orderNum_03_cursor
