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 are different types of replication in sql server?
What are number line correlation administrators will use while working with a subquery?
What are cursors stored procedures and triggers?
Where is localdb stored?
What are the 7 disadvantages to a manual system?
How to attach adventureworkslt physical files to the server?
What are null values in ms sql server?
Can you always create a cache of a report?
What is the difference between Triggers and Stored Procedure?
What do you know about system database? : SQL Server Architecture
Benefits of Stored Procedures?
What is the difference between writing data to mirrored drives versus raid5 drives
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
Can two tables share the same primary key?
What you can do to delete a table without the delete trigger firing?
