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 the native system stored procedure to execute a command against all databases?
Can an automatic recovery be initiated by a user?
What are the types of table?
Give a example to search fr a string in all stored procedure in sql server.
Explain the relational database management system (rdbms)?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
What is inner join in sql server joins?
What are distinctive joins find as a part of sql?
Explain a differential backup?
What is difference between drop truncate and delete?
What are the different types of lock modes in sql server 2000?
How to implement service broker?
What new data source types were added in ssrs 2014?
How to write a query with an inner join in ms sql server?
Explain hostprotectionattribute in sql server 2005?