Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between temp table and table variable?
- 8 Answers
- 27200 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
What is statement level trigger?
What is system stored procedures?
What are the steps to take to improve performance of a poor performing query? : sql server database administration
What is entity data services?
What is the simplest way to create a new database in ms sql server?
What is 1nf 2nf and 3nf?
What is the rdl file?
What are the filtered indexes?
Write a SQL query in order to merge two different columns into single column?
how can u get last observation in an unknown dataset ?
What stored by the master?
Why we need to use secondry database file? though, we can do same work using primary database file also.
How does using a separate hard drive for several database objects improves performance right away?
What are a scheduled jobs or what is a scheduled tasks?
What is sql server 2000 work load governor?
