SQL Server tables: what is the difference between @, # and ##?
#table refers to a local (visible to only the user who created it) temporary table.
##table refers to a global (visible to all users) temporary table.
@variableName refers to a variable which can hold values depending on its type.
Have a look at