What does the SQL # symbol mean and how is it used?

sql-server syntax symbols
Saajid Ismail picture Saajid Ismail · Jul 2, 2010 · Viewed 50.9k times · Source

Can someone please explain to me what the # symbol means in MS SQL Code.

I've tried Googling it, and even searching on StackOverflow, but can't seem to find the answer.

I feel like an idiot - having one of "those" days. Please help.

Answer

Ed Guiness picture Ed Guiness · Jul 2, 2010

They normally prefix temporary tables.

From the docs....

Prefix local temporary table names with single number sign (#table_name), and prefix global temporary table names with a double number sign (##table_name).

Related questions

Syntax of for-loop in SQL Server

What is the syntax of a for loop in TSQL?

Read More
Update Query with INNER JOIN between tables in 2 different databases on 1 server

Need some SQL syntax help :-) Both databases are on the same server db1 = DHE db2 = DHE_Import UPDATE DHE.dbo.tblAccounts INNER JOIN DHE_Import.dbo.tblSalesRepsAccountsLink ON DHE.dbo.tblAccounts.AccountCode = DHE_Import.tblSalesRepsAccountsLink.AccountCode SET DHE.dbo.…

Read More
SQL Case Expression Syntax?

What is the complete and correct syntax for the SQL Case expression?

Read More