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
Which are the olap features?
What is temporary stored procedure?
When is update_statistics command used?
what's new in sql server 2016?
What is sql profiler. What are the default templates with it? : sql server database administration
What’s the distinction between dropping a info and taking a info offline?
How to select true false based on column value in sql server?
what are the different types of SSRS reports?
What is the difference between a stored procedure and a user defined function?
Explain about merge replications?
What is hot add cpu in sql server 2008?
what are the different stages of Report Processing?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
What is difference between views and stored procedures?
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
