Xpode.com        Click here to Print this article.

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

Contributed by:
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.

Resourse address on xpode.com

Click here to go on website