Advantages and Disadvantages of Cursor?
Answer Posted / vivekanand
Merits: Row by Row Validations, good choice for small set of records
De-Merits: it Increases Network Traffic, result to slowdown the Speed and Performance of the Database,
Consumes More Resources, bad choice for large set of records.
Cheers,Vivekanand
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is primary key and example?
Why is the need for data conversion transformations?
What are the differences between lost updates and uncommitted dependencies?
How can we remove orphan records from a table?
Which is the main third-party tool used in sql server?
What is dbcc updateusage?
What are SSL and TSL protocols?
Can foreign key be deleted?
Explain primary key, foreign key and unique key?
What are the types of resultset?
What is scrollable cursor?
What happens if null values are involved in arithmetic operations?
What is use of @@ spid in sql server?
What is the difference between delete and truncate statements?
Do you know what are acid properties of transaction?