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 |
How to filter out duplications in the returning rows in ms sql server?
How is foreign key related to primary key?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
What is an entity-relationship diagram (erd)?
How many types of stored procedures are there in sql server?
What does it mean to invest in the index?
Explain about builtinadministrator?
Define Joins?
explain different types of constraints? : Sql server database administration
What are the purposes of floor and sign functions?
Explain having clause and where clause?
What's the purpose of Stored Procedure?