Can we use Cursors inside the Stored Procedure in SQL SERVER?
Vasudev Mishra
yes we can.i just give the link just have a chk http://stackoverflow.com/questions/13507317/how-to-write-a-cursor-inside-a-stored-procedure-in-sql-server-2008
Cursor is used when we need to process a set of values/fields from each record in a resultset.
Yes we can use cursor inside stored procedure in sql server
Yes, we can use Cursors inside Procedure in SQL Server.. Since Cursor operates row by row they degrade the Performance.
Yes. We Can.. But usage of cursor's will affect the performance
Yes definitely we can use.
Yes We can
we can use cursor inside sp in sql server.It causes performance degrade when we handle large amount of data in cursor. because it takes the system memory, and the table will be locked.
Yes we can use cursors in inside Stored Procedure