Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between temp table and table variable?
- 8 Answers
- 27054 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 do you create a data source?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
What are the default system databases in sql server 2000?
What is nonclustered index with included columns ?
Do you know query execution plan?
What is the use of =,==,=== operators?
What is data file in computer?
What are different types of collation sensitivity?
What are sql servers used for?
How to modify an existing user defined function?
What are the new features are introduced in sql server 2012 reporting services?
Explain aggregate functions?
What is difference between primary key and foreign key?
What are indexes in sql?
What are the differences between left join and inner join in sql server?
