What is the difference between #temptable and ##TempTable in SQL Server?
#temptable
##TempTable
#table refers to a local temporary table - visible to only the user who created it
#table
##table refers to a global temporary table - visible to all users
##table
2.1m questions
2.1m answers
60 comments
57.0k users