SQL Server 中的本地和全局临时表

Local and global temporary tables in SQL Server(SQL Server 中的本地和全局临时表)

问题描述

SQL Server 中的本地临时表和全局临时表有什么区别?

What is the difference between local and global temporary tables in SQL Server?

推荐答案

我觉得这个解释很清楚(它是从 技术网):

I find this explanation quite clear (it's pure copy from Technet):

有两种类型的临时表:本地和全局.本地临时表仅在与 SQL Server 实例的同一连接期间对其创建者可见，就像首次创建或引用这些表时一样.用户与 SQL Server 实例断开连接后，本地临时表将被删除.全局临时表在创建后对任何用户和任何连接可见，并在所有引用该表的用户与 SQL Server 实例断开连接时被删除.

There are two types of temporary tables: local and global. Local temporary tables are visible only to their creators during the same connection to an instance of SQL Server as when the tables were first created or referenced. Local temporary tables are deleted after the user disconnects from the instance of SQL Server. Global temporary tables are visible to any user and any connection after they are created, and are deleted when all users that are referencing the table disconnect from the instance of SQL Server.

这篇关于SQL Server 中的本地和全局临时表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！