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
How many levels of sp nesting are possible?
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
What is resource db in sql server?
Is port 1433 secure?
what is the system function to get current user's user id? : Sql server database administration
Explain steps of normalization?
What is the difference between lock, block and deadlock? : sql server database administration
What do you understand by triggers and mention the different types of it?
what is normalization? Explain different levels of normalization? : Sql server database administration
What is normalization and what are the advantages of it?
What is transaction server auto commit?
What does the not null constraint do?
Do you know clustered and non-clustered index?
What are wait types?
What authentication modes does sql server support?
