Interested to Buy Any Domain ? << Click Here >> for more details...
Advantages and Disadvantages of Cursor?
- 15 Answers
- 100195 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
Define full outer join?
What is ssrs?
What is clustered index
How would we use distinct statement? What is its use?
How to find the login name linked to a given user name?
What is data block and how to define data block size?
Can we deploy SSRS reports on our personal website?
Call by value and call by reference in procedure and function, with NOCOPY.
what is the difference between Tabular and Matrix report?
How connect excel to sql server?
Tell me what is the stuff and how does it differ from the replace function?
What is a DBMS, query, SQL?
Tell me what is the difference between locking and multi-versioning?
Can sql servers linked to other servers?
What are statistics?
