Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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 are the types of indexes available with SQL Server?

2 Answers   Standard Bank,

is it important for a database administrator to understand the operating system and file access? : Sql server administration

0 Answers  

What are the different types of collation sensitivity?

0 Answers  

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

0 Answers  

You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

0 Answers  

What authentication modes does sql server support?

0 Answers  

How to move database physical files in ms sql server?

0 Answers  

what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

0 Answers  

What is difference between getdate and sysdatetime in sql server 2008?

0 Answers  

What is snapshot replication?

0 Answers  

wat is the main diff between sql server 2000and sql server 2005

6 Answers   Jade Software,

What is a db view?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories