Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between temp table and table variable?
- 8 Answers
- 27055 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 is the purpose of object explorer and its features? : sql server management studio
Define full outer join in sql server joins?
What is self contained scalar sub query?
What are the differences between lost updates and uncommitted dependencies?
What is b tree index?
Differentiate between SQL and ORACLE joins and write their syntax.
How do I find the port number for sql server?
How to execute function in stored procedure sql server?
What are the different kinds of ssrs reports?
What is exporting and importing utility?
How to use the inserted and deleted pseudo tables?
What is it unwise to create wide clustered index keys?
What is difference between views and tables?
How to modify an existing user defined function?
What is efficiency data?
