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

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

747


What are the different methods available under sqlcommand class to access the data?

680


why would you call update statistics? : Sql server database administration

563


How do I make a resultset scrollable?

494


what are the important architecture components of SSRS?

92






What are relationships and mention different types of relationships in the dbms

550


How to see the event list of an existing trigger using sys.trigger_events?

564


what is a sub-report?

96


If a stored procedure is taking a table data type, how it looks?

5794


Can we call future method from trigger?

502


Can you get second highest salary from the table?

547


What is difference between commit and rollback when used in transactions?

488


Can a rule be bound to any column of any data type?

559


Is it possible to call a stored procedure within a stored procedure?

549


What do you understand by mirroring?

560