Advantages and Disadvantages of Cursor?
Answer Posted / fusion
You can perform operation on each row.
Disadv. - Consumes more resources
Is This Answer Correct ? | 55 Yes | 9 No |
Post New Answer View All Answers
What is a primary key?
What is a db view?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
What is user-defined inline table-valued function?
What is log in sql server?
Define synonym?
what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration
How to rebuild the master database?
what kind of lan types do you know? : Sql server database administration
When a primary key constraint is included in a table, what other constraints does this imply?
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
what are isolation levels? : Sql server database administration
What is normalization of database? What are its benefits?
Explain about system database?
What is conditional split?