What is difference between #Temp and ##Temp in Sql Server

Have you tried googling your question? I've searched "sql server Diff Between #Temp And ## Temp" and yields a ton of results. Here are some of them:

Hi,

 

#temp is only used by single connection in other words only one session

##temp is used by multiple connection means it will be available across session

 

Please have a look at below link.

 

https://stackoverflow.com/questions/21011276/difference-between-temptable-and-temptable 

Local Temp Table(#)- Local temp tables are only available to the SQL Server session or connection (means single user) that created the tables. These are automatically deleted when the session that created the tables has been closed. Local temporary table name is stared with single hash ("#") sign.

 

Global Temp Table(##)- Global temp tables are available to all SQL Server sessions or connections (means all the user). These can be created by any SQL Server connection user and these are automatically deleted when all the SQL Server connections have been closed. Global temporary table name is stared with double hash ("##") sign.

 

For more details refer below article :

https://www.dotnettricks.com/learn/sqlserver/difference-between-cte-and-temp-table-and-table-variable