What is the difference between temp table and table variable?
Answer Posted / nandkumar karlekar
we can create the index on temp table which leads better
performance in join and searching .
temp table can be used in exec statements.
for Table variable above two point are not applicable
| Is This Answer Correct ? | 0 Yes | 7 No |
Post New Answer View All Answers
Why should you use or avoid select * statements?
List out a number of the wants to setup a SQL Server failover cluster?
What is normalization? Describe its different types.
List out different types of normalizations in sql server and explain each of them?
What are the essential components of sql server service broker?
What is thr feature of change data capture?
What is sql server profiler trace data file?
Explain what is analysis service repository?
How to delete a login name in ms sql server?
What happens when unicode strings concatenate with non-unicode strings?
What are the components of sql server service broker?
What is the purpose of floor function?
Explain what is the function of sql server agent windows service?
How to create a Master database in SQL server ?
What is database white box testing?