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

Explain datetimeoffset data type in sal server 2008?

846

List some of the rules that apply to creating and using a ‘view’

814

What do you understand by replication in sql server? Mention the different types of replication in sql server.

890

What is SQL Azure Firewall?

134

How to use user defined functions in expressions?

1005

How to test subquery results with the exists operator?

1028

What information is maintained within the msdb database?

923

Explain the third normal form(3nf)?

890

What is the syntax for encrypting a column in SQL Server?

1049

What is checkpoint process in the sql server?

958

How does a profiler work?

870

Can we delete data from a view?

880

Explain what is sql server english query?

984

Is a primary key unique?

931

What is cube dimension? : sql server analysis services, ssas

951