Answer Posted / guest
Well cursors help us to do an operation on a set of data
that we retreive by commands such as Select columns from
table. For example : If we have duplicate records in a table
we can remove it by declaring a cursor which would check the
records during retreival one by one and remove rows which
have duplicate values.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are the advantages of user-defined functions over stored procedures in sql server?
What is open database communication (odbc)?
What is dirty page?
What are the steps you should follow to start sql server in single-user mode?
What type of locking occurs during the snapshot generation? : sql server replication
What is data source view or dsv? : sql server analysis services, ssas
How to delete an existing database user?
Determine when an index is appropriate?
What action plan is preferred if sql server is not responding?
How is foreign key related to primary key?
What is bcp? When does it used?
Explain filestream storage of sql server 2008?
What is always encrypted?
What is failover clustering overview?
What is difference between rollback immediate and with no_wait during alter database?