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


Please Help Members By Posting Answers For Below Questions

What is a primary key?

534


What is a db view?

510


how do you test proper tcp/ip configuration windows machine? : Sql server database administration

513


What is user-defined inline table-valued function?

510


What is log in sql server?

582






Define synonym?

724


what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration

559


How to rebuild the master database?

571


what kind of lan types do you know? : Sql server database administration

512


When a primary key constraint is included in a table, what other constraints does this imply?

591


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?

639


what are isolation levels? : Sql server database administration

491


What is normalization of database? What are its benefits?

511


Explain about system database?

572


What is conditional split?

532