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
- 5936 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 the types of sql server?
What is nolock hint in sql server 2008
Do you know what is lock escalation?
What is the security principal at the database level that represents your session?
What objects does the fn_my_permissions function reports on? : sql server security
What is Federation and Federation Member?
How can you manage sql azure security?
What do you understand by physical_only option in dbcc checkdb?
How do you implement session management in SQL Server mode?
How can you list all the columns in a database?
what is sql server? : Sql server database administration
What area unit the various kinds of info compression introduced in sql server 2008?
Tell me what is the order in which the sql query is executed?
Can primary key be null?
Explain ranking functions?
