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 |
Define left outer join in sql server joins?
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
Explain indexed views and partitioned view with their syntax.
What are clustered and non-clustered index?
what are the limitations of parameters in a storedprocedure
What the different types of Replication and why are they used?
How to test values returned by a subquery with the in operator?
How can you see what type of locks used?
What do you mean by acid?
How to connect sql server management studio express to sql server 2005 express?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
Explain transaction server explicit transaction?