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
- 5126 Views
- I also Faced
- E-Mail Answers
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 sql server? : Sql server database administration
What is difference between equi join and natural join?
What do you understand by mirroring?
What are the benefits and tasks of object explorer? : sql server management studio
Explain the microsoft sql server delete command? : SQL Server Architecture
what is a check constraint?
What is the architecture of ms sql reporting service?
Explain contrast amongst grouped and non-bunched records?
Differentiate between ms sql server reporting services vs crystal reports?
What is the use of for clause?
What command would you use to add a column to a table in sql server?
What are “phantom rows”?
How to start sql server browser service?
Explain different types of locks in sql server.
What are the types of joins in sql?
