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

by

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).

More Related Contents:

  1. What is the use of the square brackets [] in sql statements?
  2. incorrect syntax near keyword where [closed]
  3. How do I create a unique constraint that also allows nulls?
  4. How to convert SQL Server’s timestamp column to datetime format
  5. Multiple rows to one comma-separated value in Sql Server [duplicate]
  6. SQL Server add auto increment primary key to existing table
  7. SQL Server: Difference between PARTITION BY and GROUP BY
  8. How do you truncate all tables in a database using TSQL?
  9. SQL Server: How to select all days in a date range even if no data exists for some days
  10. Import ‘xml’ into Sql Server
  11. How do I perform a GROUP BY on an aliased column in SQL Server?
  12. Query times out when executed from web, but super-fast when executed from SSMS
  13. TSQL: How to convert local time to UTC? (SQL Server 2008)
  14. SQL Server datetime LIKE select?
  15. Adding a query hint when calling Table-Valued Function
  16. How can I import an Excel file into SQL Server? [closed]
  17. Possible to set default schema from connection string?
  18. Intermittent ODBC connection failures
  19. SQL Server Query – groupwise multiplication
  20. Entity Framework Core 2.0: How to configure abstract base class once
  21. SQL Server recursive query
  22. Getting week number off a date in MS SQL Server 2005?
  23. Commas within CSV Data
  24. How do I move a table into a schema in T-SQL
  25. How to use RANK() in SQL Server
  26. “No backupset selected to be restored” SQL Server 2012
  27. Taking the second last row with only one select in SQL Server?
  28. What is the difference between Cartesian product and cross join?
  29. How to Bulk Insert from XLSX file extension?
  30. Count number of records returned by group by

Leave a Comment