What is the difference between temp table and table variable?
- 8 Answers
- 25602 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
How to set database to be single_user in ms sql server?
List few advantages of stored procedure.
What is trigger explain with program?
How to get nth highest salary from employee table.
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
Can you import Microsoft Excel data to SSRS?
What is full outer join in sql server joins?
What are cursors and when they are useful?
What are the differences between char and varchar in ms sql server?
Can you explain full-text query in sql server?
What is the dbcc command and why is it used?
Can two tables share the same primary key?
How to get a list of all tables with "sys.tables" view in ms sql server?
How can you check the version of sql server?
what is checksum in sql server.........???
