What is the difference between Temporary table variable and a Table variable?

What is the difference between Temporary table variable and
a Table variable?

Or

Which Table variable I should use inside Stored procedure?

Question Posted / abinash

3 Answers
8564 Views
Microsoft, TCS, Techastrum, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is the difference between Temporary table variable and a Table variable? Or Which Table..

Answer / oliva

There are major theoretical differences between temporary tables:
Temp table will show below
create table #T (…)
Table var will show below
And table variables:

declare @T table (…)
scope of table var is only inside the Store Procedure.

Is This Answer Correct ?

9 Yes

1 No

What is the difference between Temporary table variable and a Table variable? Or Which Table..

Answer / jagadeesh

transation can be rollback in temptable
but in tablevaribale we cannot do this

Is This Answer Correct ?

1 Yes

0 No

What is the difference between Temporary table variable and a Table variable? Or Which Table..

Answer / kava

instance varialble

Is This Answer Correct ?

0 Yes

3 No

Post New Answer