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
- 5125 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
What are ddl triggers and types of ddl trigger?
How to create a view with data from multiple tables?
What is SQL Azure Fabric?
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
What Are the Main Features of SQL Azure?
How many primary keys are possible in a table?
What are the advantages of sql azure?
how you can deploy an ssrs report?
Tell me the use of keyword with encryption. Create a store procedure with encryption?
What is nolock?
Can we add an identity column to decimal datatype?
What is thr feature of change data capture?
How each E-R model constructs can be mapped to the relational model?
What are the various editions of sql server 2017 that are available in the market?
how you can get the list of largest tables in a database? : Sql server administration
