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
Why is the need for data conversion transformations?
What is tcl in sql server?
What is normalization? Describe its different types.
What is the difference between clustered and a non-clustered index?
What is the difference between count () and rowcount ()?
How to get all stored procedures in sql server?
What is set nocount on and what is set nocount off?
What happens if time-only values are provided as date and time literals?
What are the system database in sql server 2005?
Explain what role entity and relationship play in an ER diagram.
Define primary key?
what is the system function to get current user's user id? : Sql server database administration
What is table-valued sub query?
Difference between DELETE and TRUNCATE?
Detail about query optimizer?