Interested to Buy Any Domain ? << Click Here >> for more details...
could you please reply for these question:
1.About Use Apply?
2.Avoid cursors - When we have a situation that we can not
avoid the use of cursor than what is the alternate solution?
is there anything we can use instead of cursor to perform
the desired task? which optiomize the peroformance too.
3.What is computed columns?
Thanks in advance.
Regards,
Rupesh
- 3 Answers
- 5883 Views
- I also Faced
- E-Mail Answers
Answer Posted / prasanna
Use derived columns,corelated subqueries instead of cursors
so that the performance will also be improved.
Regards
prasanna
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the lambda triggers?
What do you mean by subquery?
What to perform pattern match with the like operator?
What is triggers and its types?
Does windows server 2016 come with sql server?
What are triggers in ms sql server?
How do I make a resultset scrollable?
Explain hostprotectionattribute in sql server 2005?
What is a non equi join?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
Explain the steps to create and execute a user-defined function in the sql server?
What is merge?
What are the options which must be set to allow the usage of optimistic models?
What are the 7 disadvantages to a manual system?
When we should use and scope of @@identity?
