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
Explain the disadvantages of cursors?
How to insert stored procedure result into temporary table?
What is a trace frag?
What sql server means?
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
What is sql server database?
How do we know if any query is retrieving a large amount of data or very little data?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
What is sql server query analyzer?
how will add additional conditions in sql?
Do you know what is difference between stored procedure and user defined function?
How to recover from sql injection? : sql server security
How we can compare two database data?
Explain alternate key, candidate key and composite key in sql server?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration