Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between temp table and table variable?
- 8 Answers
- 27189 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 format parameter in ssrs?
What are the different types of indexes?
Explain the difference between functions and stored procedures in sql server?
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
how would you troubleshoot blocking? : Sql server database administration
Explain what is row_number function?
What is the primary use of the model database?
Do you know what are pages and extents? : SQL Server Architecture
What is star, snowflake and star flake schema? : sql server analysis services, ssas
What is transaction server explicit transaction?
What is a transaction and why is it important?
What is the difference between insensitive and scroll cursor?
Tell me what are the advantages of using stored procedures?
What do you understand by a view? What does the with check option clause for a view do?
Do you know how to send email from database?
