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

Explain about integration services of Microsoft SQL server?

582


How do I setup a sql server database?

544


How to automatically create a log when an exception is being received into SQL Server?

731


What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

675


If a table does not have a unique index, can a cursor be opened on it?

513






Explain what are the restrictions that views have to follow? : SQL Server Architecture

589


Explain the difference between primary keys and foreign keys?

509


How do you implement session management in SQL Server mode?

552


Which are the new data types introduced in sql server 2008?

507


What is #table in sql server?

530


what are the critical issues you have resloved in your company

1550


What is the difference between a function and a stored procedure?

562


What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

555


How to check table values in sql server?

528


Explain transaction server isolation?

544