cursor_update.sql

来自「本程序中即有讲义」· SQL 代码 · 共 16 行

use pubs
go
declare cur_title cursor dynamic --  fast_forward dynamic KEYSET STATIC
for 
select price from titles
for update
open cur_title
declare @temp real 
fetch first from cur_title into @temp
print @temp
update titles set price=price+1 where current of cur_title
fetch first from cur_title into @temp
print @temp

close cur_title
deallocate cur_title