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
Explain about integration services of Microsoft SQL server?
How do I setup a sql server database?
How to automatically create a log when an exception is being received into SQL Server?
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
If a table does not have a unique index, can a cursor be opened on it?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
Explain the difference between primary keys and foreign keys?
How do you implement session management in SQL Server mode?
Which are the new data types introduced in sql server 2008?
What is #table in sql server?
what are the critical issues you have resloved in your company
What is the difference between a function and a stored procedure?
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?
How to check table values in sql server?
Explain transaction server isolation?