SQL Server - Create cursor in sql server

Asked By kiruba .e on 11-Feb-13 09:19 AM
Hi,

I just want to create cursor in sql server 2005.  Like stored procedure where to write cursor in sql server.

Pls help me.


Regards
kiruba.e
Robbe Morris replied to kiruba .e on 11-Feb-13 10:23 AM
You'll want to look at TABLE variables instead if your intent is to iterate through a group of records inside a stored procedure.

http://www.eggheadcafe.com/PrintSearchContent.asp?LINKID=529