Scope of temporary tables in SQL Server

by

From CREATE TABLE:

Local temporary tables are visible only in the current session

and (more importantly):

If a local temporary table is created in a stored procedure or application that can be executed at the same time by several users, the Database Engine must be able to distinguish the tables created by the different users [sic – almost certainly this should say sessions not users]. The Database Engine does this by internally appending a numeric suffix to each local temporary table name.

Which exactly rebuts the point of whoever said that they would be shared.

Also, there’s no need to DROP TABLE at the end of your procedure (from same link again):

A local temporary table created in a stored procedure is dropped automatically when the stored procedure is finished

More Related Contents:

  1. I dont know sql syntax for my table [closed]
  2. get a comma delimited string from rows [duplicate]
  3. Sequence vs identity
  4. Count Number of Consecutive Occurrence of values in Table
  5. How to correctly insert newline in nvarchar [duplicate]
  6. Find min and max for subsets of consecutive rows – gaps and islands
  7. How to get Previous Value for Null Values
  8. SQL Server: +(unary) operator on non-numeric Strings
  9. SQL where clause odd behavior [closed]
  10. How do I obtain a Query Execution Plan in SQL Server?
  11. How do I escape a single quote in SQL Server?
  12. Only inserting a row if it’s not already there
  13. Unpivot with column name
  14. Selecting data from two different servers in SQL Server
  15. Most efficient way in SQL Server to get date from date+time?
  16. How to rewrite IS DISTINCT FROM and IS NOT DISTINCT FROM in SQL Server 20008R2?
  17. How do I delete from multiple tables using INNER JOIN in SQL server
  18. SQL : BETWEEN vs =
  19. How do I perform a GROUP BY on an aliased column in SQL Server?
  20. Need to list all triggers in SQL Server database with table name and table’s schema
  21. Count based on condition in SQL Server
  22. Is it possible to perform multiple updates with a single UPDATE SQL statement?
  23. Get previous and next row from rows selected with (WHERE) conditions
  24. Best equivalent for IsInteger in SQL Server
  25. Syntax of for-loop in SQL Server
  26. Replace first occurrence of substring in a string in SQL
  27. Can SQL Server Express LocalDB be connected to remotely?
  28. How do you copy a record in a SQL table but swap out the unique id of the new row?
  29. Using IF ELSE statement based on Count to execute different Insert statements
  30. Convert bigint to datetime

Leave a Comment