I recently saw a statement like:
CREATE TABLE #tbl_AR_Data
I wanted to know what is the purpose of the symbol
# (NUMBER SIGN, hash, pound sign) in this statement?
closed as off-topic by Mark Storey-Smith, Mikael Eriksson, Max Vernon, Gaius, RolandoMySQLDBA Jul 11 '14 at 20:08
This question appears to be off-topic. The users who voted to close gave this specific reason:
'#' denotes a temporary table.
This tells SQL Server that this table is a local temporary table. This table is only visible to this session of SQL Server. When I close this session, the table will be automatically dropped.
You can treat this table just like any other table with a few exceptions. The only real major one is that you can't have foreign key constraints on a temporary table.
Read about usage and syntax here.