Temporary Tables
Temporary tables are useful as work tables to hold data while processing, such as building a table using derived data that will be referenced for further calculations.
Creating Temporary Tables
Tables are designated as temporary in SQL Server by prefacing the table name with a number sign (#). Temporary tables are created in tempdb; if they are not explicitly dropped, they are dropped when the session that created them ends. If a table is prefaced with a single pound sign (#table1), it is a private temporary table, available only to the session that created it. A table prefixed by a double pound sign (##table2) indicates that it is a global temporary table, which means it is accessible by all database connections. Global temporary ...
Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
