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
- 5886 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 ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can you leave a union at any time?
How do I find the size of a sql server database?
What is a DBMS, query, SQL?
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
What happens if null values are involved in datetime operations?
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
What is a rownum?
How to make a remote connection in a database?
What is the difference RDBMS and Graph Database?
What is a user-defined function in the sql server and what is its advantage?
Explain what are sparse columns?
What are acid properties of transaction?
what are the Prerequisites for Replication?
What security features are available for stored procedure?
What is the stuff?
