Interested to Buy Any Domain ? << Click Here >> for more details...
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
Explain the difference between cross join and full outer join?
What command would you use to create an index?
What is the purpose of grouping data in a report?
How to create sub reports?
How can you stop stored procedures from recompiling?
What are the different types of cursor?
How to connect to a sql server using odbc_connect()?
How will you add a dimension to cube? : sql server analysis services, ssas
How to test values returned by a subquery with the in operator?
Can you explain what is sql server english query?
Explain the cursor lock types?
Explain a differential backup?
What are commit and rollback in sql?
What are scalar functions?
What is triggers in ms sql server?
