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 types of columns types constraints in the sql server?
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
What do you mean by sql server 2005 express management tools?
Explain the functionalities that views support?
What is resultset concur_updatable?
You want to implement the one-to-many relationship while designing tables. How would you do it?
what is a transaction and what are acid properties? : Sql server database administration
What is a non equi join?
What is the use of set nocount on/off statement?
Explain the difference between control flow and data flow?
What is a transaction and why is it important?
What is transaction server consistency?
Is it possible in sql table to have more than one foreign key?
Explain the microsoft sql server delete command? : SQL Server Architecture
