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