SQL Server游标的使用

declare @id int
declare @name varchar(50)
declare @date varchar(50)
declare @count int=0

declare myCursor cursor for --创建游标
	select id,cnName,createDate from ent_movie a
	where a.releaseYear=2012 and a.typeid=2
open mycursor --打开游标
	fetch next from mycursor  into @id,@name,@date --读取下一行
	while(@@fetch_status=0) --是否成功读取
	begin
        set @count=@count+1
		fetch next from myCursor  into @id,@name,@date
	end
close myCursor --关闭游标
deallocate myCursor --释放游标

print @count

备注：http://www.cnblogs.com/moss_tan_jun/archive/2011/11/26/2263988.html