Difference between #temptable and ##TempTable?

sql-server temp
Vignesh Kumar A picture Vignesh Kumar A · Jan 9, 2014 · Viewed 87k times · Source

What is the difference between #temptable and ##TempTable in SQL Server?

Answer

Rahul picture Rahul · Jan 9, 2014

#table refers to a local temporary table - visible to only the user who created it

##table refers to a global temporary table - visible to all users

Related questions

SQL Server Temp Dir?

exec master..xp_cmdshell 'set' I need to get the OS temporary directory without resorting to using xp_cmdshell. I am using MSSQL 2008. What's the best way I can do that? Well, it looks like there is no way to …

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More
How do I perform an IF...THEN in an SQL SELECT?

How do I perform an IF...THEN in an SQL SELECT statement? For example: SELECT IF(Obsolete = 'N' OR InStock = 'Y' ? 1 : 0) AS Saleable, * FROM Product

Read More