What is the difference between temp table and table variable?
- 8 Answers
- 25089 Views
- Microsoft, I also Faced
- E-Mail Answers
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
Can You Use A Stored Procedure To Provide Data To An Ssrs Report?
How to round a numeric value to a specific precision?
What is the sql profiler?
what is sql server? : Sql server database administration
Is it true, that there is no difference between a rule and a check constraint?
How to stop a loop early with break statements in ms sql server?
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
What is repeatable read?
What is Lock table in SQL?
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
How to join two tables in a single query in ms sql server?
What is compression - row-level and page-level compression?
What is awe?
Explain mixed authentication mode of sql server?
What is difference between count (*) and count column?
