cursor.sql

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

use pubs
go
declare cur_title cursor FAST_FORWARD --keyset,dynamic ,static
for 
select * from titles
open cur_title
if @@error =0 
	begin
	print '游标打开成功！'
	
		print '记录数：'+convert(varchar,@@cursor_rows)
	end
close cur_title
deallocate cur_title