Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between temp table and table variable?
- 8 Answers
- 27400 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 a table be moved to different filegroup? : Sql server administration
Explain the third normal form(3nf)?
What are the types of table?
What is t-sql script to take database offline – take database online.
What are two difference between sql azure and azure tables?
Explain can SSRS reports Cache results?
Explain primary key and foreign key constraints?
Can we shrink data file in sql server?
What is the log shipping?
How to delete database objects with "drop" statements in ms sql server?
Is it possible in sql table to have more than one foreign key?
What is Federation and Federation Member?
Describe in brief authentication modes in sql server.
How to update multiple rows with one update statement in ms sql server?
What is sub query and its properties?
