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
- 5938 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
How to grant a permission in ms sql server using "grant execute" statements?
What are the properties and different types of sub-queries?
Explain what are the restrictions while creating batches in sql server?
What are the different types of collation sensitivity?
Determine when an index is appropriate?
Why would you call update statistics?
List the different normalization forms?
Does group by or order by come first?
Can we store videos inside the sql server table?
System variable and temporary variables
Name three of the features managed by the surface area configuration tool? : sql server security
How to declare and use cursor variables?
What is the impact on other user sessions when creating indexes?
Where views are stored in sql server?
How to connect of datebase with sql express.?
