I would like to know what is the diff between @<table> , #<table> and ##<table>
what I know so far is :
1) @<table> store in memory and it drop automatically once the script who call them finish.
2)#<Table> store in tempdb and we have to drop it manually inside that script.
3) I don't know what ##<table > for ? is it going to drop automatically done the script/sp/function who call it finish ? or we have to drop it manually anyway.
and it seems that SQL server can only parallel execute the data if the data is store in #<table> but not in @<table> ? how about ##<table> ?