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...

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

Or

Which Table variable I should use inside Stored procedure?

Answer Posted / jagadeesh

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

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why is the need for data conversion transformations?

978


Why we need sql server?

911


What are the different types of replication you can set up in sql server?

983


what is blocking? : Sql server database administration

981


How to delete database objects with "drop" statements in ms sql server?

1033


How to execute stored procedure in select statement sql server?

985


What is the difference between function and stored procedure in sql server?

987


How to include date and time values in sql statements?

1046


how would you improve etl (extract, transform, load) throughput?

969


Distinguish between commit and rollback?

899


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

1076


How many ways to create table-valued functions?

933


How many triggers you can have on a table?

934


What is scrollable cursor?

985


How to delete existing triggers using "drop trigger"?

990