What is the difference between temp table and table variable?
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
Why do we use non clustered index?
How to delete a database in ms sql server?
What are the purposes of floor and sign functions?
How to create a view with data from multiple tables?
A trigger can reference objects outside the current database? State true or false.
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
What are sql server functions?
Explain what is raid and what are different types of raid levels?
What are the types of subquery?
What is the purpose of the tempdb database?
What is the server name for sql management studio?
What is difference between index seek vs. Index scan?
How many non clustered indexes there can be on table ?
What do you mean by subquery?