How to avoid cursors?
Answer Posted / veeresh kethari
1.By using case.. set,we can avoid the cursors
2.By using temporary tables/table variables/CTE
with while loop we can avoid cursor in the transaction.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Which are the olap features?
what is new philosophy for database devises for sql server 7.0? : Sql server database administration
What is page-level compression?
Does transparent data encryption provide encryption when transmitting data across the network?
What is a non clustered primary key?
What is data set in report?
What is transaction server consistency?
Explain different forms of normalization?
Why olap is used?
What is usually the first word in a sql query?
What are binary string data types in ms sql server?
What is Federation and Federation Member?
What are sub reports and how to create them?
What is parameterized reports in ssrs ?
What is field with example?