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
Tell me about the approaches which you used to counter the DI problems.
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What is serializable?
What are the differences between left join and inner join in sql server?
What will be the maximum number of indexes per table?
Why are you getting errors when creating a new odbc dsn?
Define full outer join?
How to use go command in "sqlcmd"?
How many types of database relationship in sql server?
Do you know what are acid properties?
what is package and it uses and how can u call a package
How to modify existing triggers using "alter trigger"?
How to name query output columns in ms sql server?
Explain the ways to controlling cursor behavior?
What is field with example?