Advantages and Disadvantages of Cursor?
Answer Posted / bed singh
1. We can do row vise validation but performance is
slow.
2. Each time we fetch a row from the cursor, it result
a network round trip, where as a normal select statement
query make only one round trip.
3. If the ResultSet is less than 50 or 100 records it
is better to go for implicit cursors. If the result set is
large then you should use explicit cursors. Otherwise it
will put Burdon on CPU.
Is This Answer Correct ? | 43 Yes | 12 No |
Post New Answer View All Answers
What is public role in sql server?
What is the most common type of join?
What are the differences between sql server and mysql.
What is replace and stuff function in sql server?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
Explain an automatic checkpoint
How to modify an existing stored procedure in ms sql server?
What are the advantages of log shipping?
How to enter binary string literals in ms sql server?
What is mean by candidate key?
What stored by the master? : sql server database administration
what changed between the previous version of sql server and the current version? : Sql server database administration
How to return the top 5 rows from a select query in ms sql server?
Does dbcc checkdb requires db to be in single_user mode? : sql server database administration
Explain how to send email from sql database?