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 create statement?
Explain few examples of stored procedure over triggers?
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
What is the osql utility?
How to fetch the next row from a cursor with a "fetch" statement?
How can you control the amount of free space in your index pages?
Is null in sql server?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
explain databases and sql server databases architecture? : Sql server database administration
What information is maintained within the msdb database?
What is difference between line feed ( ) and carriage return ( )?
What is the bookmark lookup and rid lookup?
optimization techinques
How do I setup a local sql server database?