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

What are the basic features of a trigger in ms sql server?

791


Explain nested join?

738


What is query optimization process?

716


Does server sql treat char as a variable-length or fixed-length column?

784


What is ms sql server service broker?

680






What is spid in sql server profiler?

726


Equi join and non equi join is possible with sql server?

661


What is open database communication (odbc)?

750


How to create a login account in ms sql server to access the database engine using "create login" statements?

735


What is cte (common table expression)?

768


what is a mixed extent? : Sql server administration

750


do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

671


How to count groups returned with the group by clause in ms sql server?

738


Define left outer join?

756


Define Unique Key?

763