Interviews - C# Corner

Vasudev Mishra
Can we use Cursors inside the Stored Procedure in SQL SERVER?
By Vasudev Mishra in SQL Server on Nov 29, 2012
  • Bhabani Prasad
    May, 2014 23

    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

    • 1
  • Sunil Babu
    Apr, 2016 2

    Cursor is used when we need to process a set of values/fields from each record in a resultset.

    • 0
  • Irshad Ahmad
    Feb, 2013 21

    Yes we can use cursor inside stored procedure in sql server

    • 0
  • Shankar M
    Feb, 2013 18

    Yes, we can use Cursors inside Procedure in SQL Server.. Since Cursor operates row by row they degrade the Performance.

    • 0
  • Thameem Ansari
    Feb, 2013 7

    Yes. We Can.. But usage of cursor's will affect the performance

    • 0
  • Rishikesh Kumar  Singh
    Jan, 2013 31

    Yes definitely we can use.

    • 0
  • Koteeswaran Lakshmikanth
    Jan, 2013 30

    Yes We can

    • 0
  • Mukesh Km
    Jan, 2013 25

    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.

    • 0
  • Chetan Kumar
    Jan, 2013 4

    Yes we can use cursors in inside Stored Procedure

    • 0

C# Corner Chandigarh Developer Conference

Most Popular Companies

Most Popular Job Functions

MOST LIKED QUESTIONS