Interested to Buy Any Domain ? << Click Here >> for more details...
How to avoid cursors?
- 3 Answers
- 8718 Views
- CarrizalSoft Technologies, HP, I also Faced
- E-Mail Answers
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 is role playing dimension with two examples? : sql server analysis services, ssas
what's the difference between delete table and truncate table commands? : Sql server database administration
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
Is it possible to replicate data from sql server to oracle? : sql server replication
Can We Use Data-grids For Our Report In Ssrs?
Can we call future method from queueable?
What is attribute relationships, why we need it? : sql server analysis services, ssas
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
In which format does an image save in SQL Server database ?
What is a cube? : sql server analysis services, ssas
How do I completely remove sql server instance?
How to configure and test odbc dsn settings?
What options are available to audit login activity? : sql server security
How do I save a stored procedure in sql server?
What is tcl in sql server?
