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