Temporary Tables: Local vs. Global | Software Development content from SQL Server Pro
A local temporary table, #table_name, exists only for the duration of a user session or the procedure that created the temporary table. When the user logs off or when the procedure that created the table completes, the local temporary table is lost. Multiple users can't share a local temporary table because it is local to one user session. You also can't grant or revoke permissions on the local temporary table. (See also, "Table Variables vs. Temporary Tables").
Read full article from Temporary Tables: Local vs. Global | Software Development content from SQL Server Pro
No comments:
Post a Comment