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 extended events?

538

What is ems sql management studio? : sql server management studio

582

What is difference between unique and primary key?

474

Does union all remove duplicates?

605

Explain system scalar functions?

570

What is awe?

563

What is the difference between functions and stored procedures?

610

What do you mean by SQL injection attack?

609

How to find tables without indexes?

622

How ssrs maintain security?

572

How do I view a procedure in sql server?

529

Can a table be moved to different filegroup?

564

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

492

How to see existing views in ms sql server?

533

What is SubQuery in SQL Server 2008

545