What is the difference between temp table and table variable?
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
tell me what is blocking and how would you troubleshoot it? : Sql server database administration
Why does sql studio use a single registered database repository? : sql server management studio
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
What are the database objects? : SQL Server Architecture
Mention the differences between substr and charindex in sql server.
What are user-defined functions (udfs) in sql server?
How to test values returned by a subquery with the in operator?
How to end a stored procedure properly in ms sql server?
What are sql server procedures?
How to get the definition of a trigger back?
What is dbcc updateusage?
Explain active/passive and active/active cluster configurations?
explain different types of constraints? : Sql server database administration
What is shrink log file?
Can a table be created inside a trigger?