What is the difference between temp table and table variable?
Answer Posted / rathikapoobalan
1. If we use Temporary Table in a stored procedure, We
should drop it at the end.
It is not necessary in the case of Table variable.
2. In Table variable we can hold maximum of 20000 records
only. If it exceeds, we can use temporary table
Is This Answer Correct ? | 11 Yes | 16 No |
Post New Answer View All Answers
How does stuff differ from the replace function?
What do you mean by an execution plan? Why is it used?
What are examples of triggers?
System variable and temporary variables
How retrieve field names from the table in SQL through JAVA code?
How to use order by with union operators in ms sql server?
What are the advantages of sql azure?
What do you understand by the denormalisation?
What are the properties and different types of sub-queries?
What is page in sql server?
What is data file in computer?
Explain about system stored procedure?
What is the difference between Clustered and Non-Clustered Index?
Which data type columns are the best candidates for full-text indexing?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?