Interested to Buy Any Domain ? << Click Here >> for more details...
Advantages and Disadvantages of Cursor?
- 15 Answers
- 100914 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
How to provide values to user defined function parameters?
How can I tell if sql server is 32 or 64 bit?
What is the difference between cube operator and rollup operator? : SQL Server Architecture
How to find table changes in sql server?
After removing a table from database, what other related objects have to be dropped explicitly?
How to use subqueries with the in operators in ms sql server?
What is the maximum length of an alert name?
What are the advantages of using stored procedures?
What do you understand by triggers?
How to insert stored procedure result into temporary table?
Define right outer join in sql server joins?
What is the stuff and how does it differ from the replace function?
What is database mirroring?
What stored procedure would you use to view lock information?
How can we call UDF(User Define Function) using C# code in ASP.net ?
