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 the different acid properties?
Explain about builtinadministrator?
Scalability, Availability, Integration with internet, etc.)?
Explain where clause?
What is isnull() operator?
How do you debug a procedure in sql server?
What is sqlservr.exe - process - sql server (sqlex?press)?
What is meant by Active-Passive and Active-Active clustering setup?
what are the different types of replication you can set up in sql server? : Sql server database administration
Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration
What is triggers and its types?
What are the operating modes in which database mirroring runs?
Is null in sql server?
What do you understand by triggers and mention the different types of it?
Explain what are the restrictions while creating batches in sql server?
