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
Answer Posted / 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 |
Post New Answer View All Answers
What is the xml datatype?
Can you force a query to use a specific index?
How to name query output columns in ms sql server?
What is attribute hierarchy? : sql server analysis services, ssas
What does top operator do?
What are the built in functions in sql server?
Can two tables share a primary key?
What are the different editions available in sql server 2000?
What is tabulation?
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
How to create nested stored procedure?
What do you mean by data integrity?
Which database stores information about replication?
What is explicit cursors?
What is pessimistic concurrency?