SQL Server tables: what is the difference between @, # and ##?

by

#table refers to a local (visible to only the user who created it) temporary table.

##table refers to a global (visible to all users) temporary table.

@variableName refers to a variable which can hold values depending on its type.

More Related Contents:

  1. incorrect syntax near keyword where [closed]
  2. nvarchar concatenation / index / nvarchar(max) inexplicable behavior
  3. How do I get list of all tables in a database using TSQL?
  4. Escape a string in SQL Server so that it is safe to use in LIKE expression
  5. SQL time difference between two dates result in hh:mm:ss
  6. Storing files in SQL Server
  7. Dapper.NET and stored proc with multiple result sets
  8. “order by newid()” – how does it work?
  9. Import ‘xml’ into Sql Server
  10. Query times out when executed from web, but super-fast when executed from SSMS
  11. T-SQL Dynamic SQL and Temp Tables
  12. Efficient ISNUMERIC() replacements on SQL Server?
  13. How to determine total number of open/active connections in ms sql server 2005
  14. Login to Microsoft SQL Server Error: 18456
  15. Find non-ASCII characters in varchar columns using SQL Server
  16. Disadvantages of MARS (Multiple Active Result Sets)?
  17. SQL Server Output Clause into a scalar variable
  18. Replace single quotes in SQL Server
  19. Why is sql server storing question mark characters instead of Japanese characters in NVarchar fields?
  20. sql use statement with variable
  21. How to create a yes/no boolean field in SQL server?
  22. Copy table to a different database on a different SQL Server
  23. Include missing months in Group By query
  24. How to set value to variable using ‘execute’ in t-sql?
  25. Data generators for SQL server? [closed]
  26. Taking the second last row with only one select in SQL Server?
  27. SQL Server Maximum rows that can be inserted in a single insert statment
  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