sql-server – SQL Server多用户中的临时表是否安全？

解决方法

MSDN:

Local temporary tables are visible
only in the current session,and
global temporary tables are visible to
all sessions

…

A local temporary table created in a
stored procedure is dropped
automatically when the stored
procedure is finished. The table can
be referenced by any nested stored
procedures executed by the stored
procedure that created the table. The
table cannot be referenced by the
process that called the stored
procedure that created the table.

All other local temporary tables are
dropped automatically at the end of
the current session.

Global temporary tables are automatically dropped when the session that created the table ends and all other tasks have stopped referencing them. The association between a task and a table is maintained only for the life of a single Transact-SQL statement. This means that a global temporary table is dropped at the completion of the last Transact-SQL statement that was actively referencing the table when the creating session ended.

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!