2

I'm creating an application in C# that calls multiple stored procedures. One of the stored procedure creates a table and the others query that table. Multiple users can use the application at the same time. What table would be appropriate in this case to prevent data collision when using the same table name?

Brian Tompsett - 汤莱恩
  • 5,753
  • 72
  • 57
  • 129
D R
  • 125
  • 1
  • 1
  • 4

1 Answers1

1

SQL Server supports two different kinds of temporary tables: local and global.

Local #temporary tables are only visible to the session that created them.

Global ##temporary tables are visible to all sessions.

For more information, see the "Temporary Tables" section of the TechNet article here.

Gord Thompson
  • 116,920
  • 32
  • 215
  • 418