What is the difference between temp table and table variable?
- 8 Answers
- 25601 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
Can You Use A Stored Procedure To Provide Data To An Ssrs Report?
Can we use where clause with group by?
What is awe?
how we use window authentication connection with sql server.?
Explain the purpose of indexes?
Can group by and orderby be used together?
Explain the working of sql privileges?
What is the contrast amongst drop and truncate?
Can two tables share a primary key?
What is subquery? Explain the properties of a subquery?
how many triggers you can have on a table? : Sql server database administration
How do you create an execution plan?
John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
What are number line correlation administrators will use while working with a subquery?
