why we use cursor?

Answers were Sorted based on User's Feedback



why we use cursor?..

Answer / yoshita kundwani

Cursors can be considers as named result sets which allow a
user to move through each record one by one.

Is This Answer Correct ?    37 Yes 1 No

why we use cursor?..

Answer / anil

Cursor allow row by row fetching records

Is This Answer Correct ?    22 Yes 5 No

why we use cursor?..

Answer / manoj kumar singh

When we want to update row depending on certain criteria. we
will loop through all rows and update data accordingly.
There's where cursors come in to picture.

Is This Answer Correct ?    18 Yes 7 No

why we use cursor?..

Answer / sid

Cursors can be considers as named result sets which allow a
user to move through each record one by one.

Is This Answer Correct ?    14 Yes 3 No

Post New Answer

More SQL Server Interview Questions

What does the automatic recovery do?

0 Answers  


What are system databases into sql server (2005/2008)?

0 Answers  


What is your recommendation for a query running very slow? : sql server database administration

0 Answers  


What command do we use to rename a db?

5 Answers   IBM,


Write the Syntax for Cursors.

2 Answers   CarrizalSoft Technologies, HP,






What is the difference between having clause and where clause in sql server?

0 Answers  


What is mscorsvw.exe - process - microsoft .net framework ngen?

0 Answers  


Explain DBCC?

0 Answers   QuestPond,


Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

0 Answers  


How can you check the version of sql server?

0 Answers  


how many instance use in sql server 2005

4 Answers   EFI, HCL,


How To Change Column Ordinal Position in SQL Server 2005 using Query i.e I Want To Add Column at Particular Ordinal Position in SQL Server 2005

2 Answers  


Categories