SQL Server中的本地和全局临时表 [英] Local and global temporary tables in 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中的本地和全局临时表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！