What is the difference between temp table and table variable?
- 8 Answers
- 24704 Views
- Microsoft, I also Faced
- E-Mail Answers
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
What command is used to delete a table from the database in the sql server and how?
Why do we use sql limitations? Which constraints can we use while making a database in sql?
What are various aggregate functions that are available?
How to enter comments in transact-sql statements?
What are scalar functions in sql?
What is the default sql server instance name?
Tell me about the approaches which you used to counter the DI problems.
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
What is self contained scalar sub query?
How to resolve the orphan use problem? : sql server security
What is sql view?
What is user-defined functions? What are the types of user-defined functions that can be created?
How do I clean up sql server transaction log?
Can a trigger be created on a view?
What are “lost updates”?
