Question

sql server2008怎么删除游标？？？？

Answer 1

百度的实例，最后就是删除游标吧
use database1
declare my_cursor cursor scroll dynamic
/**//*scroll表示可随意移动游标指 针（否则只能向前），dynamic表示可以读写游标（否则游标只读）*/
for
select productname from product
open my_cursor
declare @pname sysname
fetch next from my_cursor into @pname
while(@@fetch_status=0)
begin
print 'Product Name: ' + @pname
fetch next from my_cursor into @pname
end
fetch first from my_cursor into @pname
print @pname
/**//*update product set productname='zzg' where current of my_cursor */
/**//*delete from product where current of my_cursor */
close my_cursor
deallocate my_cursor

Answer 2

游标使用完，先用CLOSE语句关闭它，然后用DEALLOCATE语句释放游标即可。