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
What are the main sources of data?
What are the difference between primary keys and foreign keys?
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
What happens when unicode strings concatenate with non-unicode strings?
How to filter out duplications in the returning rows in ms sql server?
What is 'Join' and explain its various types.
What are the restrictions applicable while creating views? : SQL Server Architecture
Explain system rowset functions?
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
What is the cpu pressure?
What is store procedure? How do they work? When do you use?
What is the order by used for?
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
Does an index slow down updates on indexed columns?
How would you go about developing a ssrs report?