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

what is a live lock? : Sql server database administration

500

what data regions are and what are the different data regions?

101

What is default port number for sql server 2000?

600

Is mysql better than sql server?

542

Give a example to search fr a string in all stored procedure in sql server.

537

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

557

Explain cdc and sql injection?

550

Can two tables have the same primary key?

567

List out the differences between the clustered index and non-clustered index in sql server?

506

Explain raiserror in sql server?

577

What are the different types of triggers in SQL SERVER?

541

What are the extra roles available in msdb? : sql server security

642

Explain datetimeoffset data type in sal server 2008?

542

What is self contained multi valued query?

560

How do you trace the traffic hitting a sql server?

618