Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between temp table and table variable?
- 8 Answers
- 27142 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 we call stored procedure in view in sql server?
how would you store your query in an SSRS report or a Database server?
What are logical database components? : SQL Server Architecture
Explain Normalization and DE normalization
What does the on update no action do?
What is a transact-sql statement batch in ms sql server?
What are date and time data types in ms sql server?
What are the types of stored procedures in an sql server?
How to make conditional sum in ssrs?
Explain the categories of stored procedure?
What is the process of normalization?
How to automatically create a log when an exception is being received into SQL Server?
How to get a list of all tables with "sys.tables" view in ms sql server?
How do you run a trace?
What is read committed?
