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
- 6044 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
Explain sql delete command?
What is sql server schema compare? How we can compare two database schemas?
Can you tell me some of the common replication dmv's and their use? : sql server replication
Mention the different authentication modes in sql server.
How to provide values to user defined function parameters?
What are constraints?
How do indexes help, types?
Would you store your query in a ssrs report or a database server? State the reason why?
Where are SQL server users names and passwords are stored in sql server?
What is the difference between index seek vs. Index scan?
Why normalization is used?
Does table partitioning improve performance?
What is a system database and what is a user database?
How to drop an existing schema in ms sql server?
Explain partitioned view?
