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 are the basic features of a trigger in ms sql server?
Explain nested join?
What is query optimization process?
Does server sql treat char as a variable-length or fixed-length column?
What is ms sql server service broker?
What is spid in sql server profiler?
Equi join and non equi join is possible with sql server?
What is open database communication (odbc)?
How to create a login account in ms sql server to access the database engine using "create login" statements?
What is cte (common table expression)?
what is a mixed extent? : Sql server administration
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
How to count groups returned with the group by clause in ms sql server?
Define left outer join?
Define Unique Key?