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 are page splits?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?
Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?
Why is DML provided?
1 Answers Ernst Young, Thomson Reuters,
Can we perform backup restore operation on tempdb? : sql server database administration
How can i Relate Tables in SSIS
What methods do you follow to protect from sql injection attack?
What is the difference between UNIQUE and DISTINCT keywords in DBMS?
How to find the date and time of last updated table?
Can two different columns be merged into single column? Show practically?
Write a SQL query to make a column as unique?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)