What is the difference between temporary table and temporary variable



Table variables are Transaction neutral. They are variables and thus are not bound to a transaction. Temp tables behave same as normal tables and are bound by transactions. declare @var table (id int, data varchar(20) ) create table #temp (id int, data varchar(20) )




Share this article \| Print \| Article read by 1981 times
Author: Guest Guest user is that user who have done some activity on website without login. Activity contains commenting on any article, uploading an image on website etc.	Related Articles: What is the difference between char, nchar, var... Related Interview Questions: What is the difference between char, nchar, var... What is difference between nchar & nvarchar... What is the difference between temporary table ... Can i Rollback the Table DataTypes while using ...