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


Please Help Members By Posting Answers For Below Questions

You are doing log shipping due to some reasons it is failing. How you will proceed from there

1628


How to create an inline table-valued function?

628


What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

829


How to filter records of table in SQL SERVER?

687


Can one drop a column from a table?

636






How do I start sql server agent automatically?

591


What according to you is the difference between mysql and sql server performance?

652


What are the properties of sub-query?

677


What is sql azure database?

190


what is normalization? Explain different levels of normalization? : Sql server database administration

761


tell me the disaster recovery plan

2109


Give me a SQL Query to find out the second largest company?

799


What are the joins in sql server? : sql server database administration

633


What does Master database contains?

711


What are the different normalization forms?

716