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
- 4866 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
Are null values the same as that of zero or a blank space?
What is 3nf normalization form?
What is difference between drop truncate and delete?
What have included columns when we talk about sql server indexing?
What do you understand by triggers and mention the different types of it?
Explain an incremental backup?
What is a view and what are its advantages?
How to get the query of a table in sql server?
What are “lost updates”?
What is the difference between a function and a stored procedure?
What are the dis_advantages of stored procedures, triggers, indexes?
What is the full form of ddl?
What is model database in sql server?
Why truncate is ddl?
What is the function of inner join?
