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
How to reaname table name without using sp_Rename in sql server..?
Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?
Explain the properties of sub-query in sql server?
Can you insert NULL in unique column?
Name three of the features managed by the surface area configuration tool? : sql server security
How do I run sql server 2014?
How to find tables without indexes?
What are the recovery models in sql server 2000?
How to throw custom exception in Stored Procedure?
Explain syntax for viewing, dropping and disabling triggers?
What is in place upgrade in sql server?
Do you know what is bit data type and whats the information that can be stored inside a bit column?
What is ssrs?
What is the difference between for trigger and after trigger?
What is log cache in sql server?