Interested to Buy Any Domain ? << Click Here >> for more details...
Advantages and Disadvantages of Cursor?
- 15 Answers
- 100874 Views
- Polytechnic, TCS, Zenith, I also Faced
- E-Mail Answers
Answer Posted / sarat
Cursors allow row-by-row processing of the resultsets.
Disadvantages of cursors: Each time you fetch a row from the
cursor, it results in a network roundtrip, where as a normal
SELECT query makes only one rowundtrip, however large the
resultset is. Cursors are also costly because they require
more resources and temporary storage (results in more IO
operations). Further, there are restrictions on the SELECT
statements that can be used with some types of cursors.
Most of the times, set based operations can be used instead
of cursors.
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
Which sql server table is used to hold the stored procedure script?
What options are available to audit login activity? : sql server security
How to delete all rows with truncate table statement in ms sql server?
How do you delete a trigger?
What is an active database?
What do you mean by a dependent functionality in a build?
What is difference between cte and view?
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
What is inline variable assignment?
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
last function used in MS Access to convert sql what function will use in sql
Why use view instead of a table?
What is the sql server 2000 version number?
Explain boyce and codd normal form(bcnf)?
How to remove duplicate rows from table?
