Advantages and Disadvantages of Cursor?
- 15 Answers
- 96650 Views
- Polytechnic, TCS, Zenith, I also Faced
- E-Mail Answers
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 are the disadvantages of primary key and foreign key in SQL?
How to create a local temporary stored procedure?
Explain security with sql azure?
What is an expression in ms sql server?
What stored by the model? : sql server database administration
How can you list all the columns in a database?
How can you fetch alternate records from a table?
What is filestream?
What are transactions in sql?
How to use transact-sql statements to access the database engine?
Please differentiate between a local and a global temporary table?
What happens if time-only values are provided as date and time literals?
What is difference between stored procedure and user defined function?
What is attribute relationships, why we need it? : sql server analysis services, ssas
What do you mean by data integrity?
