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
- 4867 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
How to list all login names on the ms sql server?
Explain what is the main purpose of having conversation group?
How to use subqueries with the exists operators in ms sql server?
Working with TLogs
How to execute stored procedure and set temp table in sql server?
What are partitioned views and distributed partitioned views?
What is the default sql server instance name?
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
Write down the syntax and an example for create, rename and delete index?
What is trigger in salesforce?
What is explicit mode in sql server?
What is the beast way to write CTE in SQL Server ?
What are the various editions of sql server 2017 that are available in the market?
What is dirty read?
