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
What is indexing and its types?
What is 1nf normalization form?
What is a group function explain with an example?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
What is SQL Azure Fabric?
What is forward - only cursors / read only cursor?
What is a schema in ms sql server 2005?
explain declarative management framework (dmf) in sql server 2008?
What is the importance of a recovery model?
What are the properties of the transactions?
How you can change the database name in SQL SERVER?
What is a transact-sql statement?
Tell me about the approaches which you used to counter the DI problems.
Write a program using SQL queries to find a unique entry in a table.