why we use cursor?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
What does the automatic recovery do?
What are system databases into sql server (2005/2008)?
What is your recommendation for a query running very slow? : sql server database administration
What command do we use to rename a db?
Write the Syntax for Cursors.
2 Answers CarrizalSoft Technologies, HP,
What is the difference between having clause and where clause in sql server?
What is mscorsvw.exe - process - microsoft .net framework ngen?
Explain DBCC?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
How can you check the version of sql server?
how many instance use in sql server 2005
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