1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

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

More SQL Server Interview Questions

What is a trigger in sql server?

0 Answers  

What is the differecne between equi-join and inner-join and natural join..Is there any difference or all are same?

8 Answers   Microsoft,

How to throw custom exception in Stored Procedure?

0 Answers   MCN Solutions,

what is normalization? : Sql server database administration

0 Answers  

What is attribute relationships, why we need it? : sql server analysis services, ssas

0 Answers  




how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

0 Answers  

How many index can be created for single table

4 Answers   CarrizalSoft Technologies, Verizon,

What are different types of replication in sql server?

0 Answers  

How do I setup a local sql server database?

0 Answers  

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

0 Answers  

How to create a new table in a given schema?

0 Answers  

when inserting to a table how many rows will be effected using triggers

2 Answers  

For more SQL Server Interview Questions Click Here
Categories