temp tables physically exists in temp DB but temp variables does not exist

What is the difference between temp table and table variable?

Question Posted / samba shiva reddy . m

Answer Posted / samba shiva reddy . m

temp tables physically exists in temp DB
but temp variables does not exists.

Is This Answer Correct ?

4 Yes

13 No

Please Help Members By Posting Answers For Below Questions

How do I setup a local sql server database?

1006

What is the current limitation of the size of SQL Azure DB?

127

How do I save a stored procedure in sql server?

996

How to find out what is the default collation in a database?

1121

can you implement data mining in SSRS?

148

Explain nested trigger in sql?

1071

How to apply filtering criteria at group level with the having clause in ms sql server?

1002

How the authentication mode can be changed?

1132

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

1083

What are the different types of backups avaialabe in sql server 2005?

1020

What is a rownum?

976

What triggers long term care?

1033

System requirements for sql server 2005 express edition?

1014

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

1032

What is the use of tempdb? What values does it hold?

1072