一般来说，Cursor有其优点，但缺点更多.我在应用程序中使用了一种简单的方法，并处理大量数据.
检查此

http://d4dilip.wordpress.com /2010/04/15/avoid-use-of-sp_xml_removedocument-and-cursor-in-stored-procedure/ [

In general Cursor has its pros but more cons. I have using an simple approach in in my applicaiton and working with huge amount of data .
check this

http://d4dilip.wordpress.com/2010/04/15/avoid-use-of-sp_xml_removedocument-and-cursor-in-stored-procedure/[^]