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 |
Can binary strings be converted into numeric or float data types?
How can you set the threshold at which sql server will generate keysets asynchronously?
i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.
How to start sql server browser service?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
What is the exact numeric data type in sql?
What is a trigger?
what is a self join? Explain it with an example? : Sql server database administration
Explain DBCC?
How to connect to a sql server using odbc_connect()?
What is database architecture? : SQL Server Architecture
How to make a column nullable?
Oracle (3253)
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)