Advantages and Disadvantages of Cursor?

Answer Posted / karthikumar.r

advantage:we can do row vise validation.
disadvantage:performance is less

Is This Answer Correct ?    103 Yes 18 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you identify a foreign key?

690


What is nolock?

644


What are the database objects? : SQL Server Architecture

624


What is the difference between Normalization and De-normalization?

671


Explain the Ways to improve the performance of a sql azure database?

72






Explain what is the use of custom fields in report?

590


How do I open a .db file?

578


Why should we go for stored procedures? Why not direct queries?

655


What is the use of toad or sqldbx.?

813


What is the difference between clustered index and primary key?

589


Describe in brief authentication modes in sql server.

653


What it means to be triggered?

586


How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

703


How do you drop an index?

583


Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

631