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

What is the purpose of a table?

723


Do you know what is a with(nolock)?

790


What is instead of dml trigger?

771


What is GUID in sql server?

819


What is the difference between primary key and unique constraints?

667






Explain the difference between delete,drop and truncate in SQL Server?

770


what are constraints? : Sql server database administration

715


What is #table in sql server?

739


What is the difference between mysql and mysqli?

752


How can you insert values in multiple rows using one Insert statement?

800


How can delete duplicate records in cte in sql server?

698


Difference between Inner vs outer joins?

690


How does clustered and non clustered index work?

679


How to manipulate data from one table to another table ?

717


Is INSTEAD OF trigger directly applicable to Table ?

735