What is the difference between temp table and table variable?
- 8 Answers
- 25088 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / samba shiva reddy . m
temp tables physically exists in temp DB
but temp variables does not exists.
| Is This Answer Correct ? | 4 Yes | 13 No |
Post New Answer View All Answers
What is the chart in report?
Can we check locks in database? If so, how can we do this lock check?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
What is the difference between web edition and business edition?
What is a performance monitor?
How to verify a user name with sqlcmd tool?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
Explain different backup plans?
What is normalization and its types?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
What is report server project?
Explain the flow of creating a cube? : sql server analysis services, ssas
What are the different types of sub-queries?
List few advantages of stored procedure.
Explain stored procedure?
