Advantages and Disadvantages of Cursor?
Answer Posted / ruchita
Adv:cursor is a private sql area in which
row by row operatioms and validations can be done
disadv:resource reqired are more
Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
What is the difference between deallocate cursor and close cursor?
Why we need to use secondry database file? though, we can do same work using primary database file also.
How do you rebuild an identity column?
What are the advantages of using a stored procedure?
What are recommended options to be used while using db mirroring? : sql server database administration
What is the distinction amongst delete and truncate?
You want to implement the many-to-many relationship while designing tables. How would you do it?
How will you monitor replication latency in transactional replication? : sql server replication
Can you tell me about the concept of ER diagrams?
What are acid properties of transaction?
What are the benefits and tasks of object explorer? : sql server management studio
How many instances per computer are there in sql server 2000?
What you can do to delete a table without the delete trigger firing?
What are secondary xml indexes?
What does truncate do?