Click here to hide categories Click here to show left categories

User: Home          welcome : Guest          Log In / Register here     

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 1849 times
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:
Related Interview Questions: