Answer Posted / sandeep
Cursor is a database object even it is treated like a data
type. It is generally used for fast and resource efficient
programming. Cursor wont fetch all datas resulted from a
select statement. Only one row at a time. this speeds up
the population of the data. In select statement all datas
shud be fetched to the client machine. Few drawbacks are
there with cursor but in some cases it works well.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the use of floor function in sql server?
How can sql injection be stopped? : sql server security
What are null values in ms sql server?
What are “phantom rows”?
Can a database be shrunk to 0 bytes, if not, why?
What is index fragmentation in ms sql server?
What is the purpose of the model database?
What is the standby server?
What do you mean by data manipulation language?
What are the export options of ssrs?
How do you debug a procedure in sql server?
What is dbcc? Give few examples.
What is the sql case statement used for? Explain with an example?
How to use subqueries with the in operators in ms sql server?
How to create dbo table in sql server?