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
What are some examples of schemas?
How do I run sql server 2014?
What is raid, and how it can influence database performance?
Explain primary key, foreign key and unique key?
When should you use an instead of trigger?
Explain how you can deploy an SSRS report?
How do I manually uninstall an instance of sql server 2016?
explain different types of joins? : Sql server database administration
What is a primary key?
What is set nocount on?
What are the encryption mechanisms in sql server?
What is nonclustered index with included columns ?
What is the data type of time?
How to download microsoft sql server 2005 express edition?
How to disable stored procedure sql server?
