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
Answers were Sorted based on User's Feedback
Answer / anupom das
Use Table variable with a identity column. Then make a while
loop row by row
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / anupom das
Use Table variable with a identity column. Then make a while
loop row by row
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
How many instances per computer are there in sql server 2000?
What is the disadvantages of index?
How To Find That One Week Change in My DataBase we Have Done Like We Have A database Test I Change Table,Stored Procd. Then I Find Which SP,Table We Have Edit/Change in Seven Dayes
Explain difference between control flow and data flow?
Can you insert NULL in unique column?
What is the purpose of the tempdb database?
What is transaction server isolation?
What are the steps you will take to improve performance of a poor performing query?
What do you think of this implementation? Can this be implemented better?
How to get the definition of a stored procedure back?
Which institute is best for SQL Server 2005 Training?
What happens if the update subquery returns multiple rows in ms sql server?