Answer Posted / pervej munjal
Cursor plays there row quite nicely but although there are
some disadvantage of Cursor .
Because we know cursor doing roundtrip it will make network
line busy and also make time consuming methods. First of
all select query gernate output and after that cursor goes
one by one so roundtrip happen.Another disadvange of cursor
are ther are too costly because they require lot of
resources and temporary storage so network is quite busy.
Site of Dot net and sql server
("http://www.dotnetquestion.info")
<a href="http://www.dotnetquestion.info">link</a>
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are ddl triggers and types of ddl trigger?
What are sql dirty pages?
Explain what are commit and rollback in sql?
What is a view and what are its advantages?
How to enter date and time literals in ms sql server?
What is the current limitation of the size of SQL Azure DB?
How to enter unicode character string literals in ms sql server?
What is a bit datatype?
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
application server is slow what may be the problem
Explain the use of containers in ssis and also their types?
Is it important for a database administrator to understand the operating system and file access?
What is thr feature of change data capture?
What is the purpose of optimization?
What is table constraint?
