SQL Server 中的临时表导致“已经有一个名为的对象"错误 [英] Temporary table in SQL server causing ' There is already an object named' error

问题描述

我在 SQL Server 中遇到以下问题，我有一些如下所示的代码:

I have the following issue in SQL Server, I have some code that looks like this:

DROP TABLE #TMPGUARDIAN
CREATE TABLE #TMPGUARDIAN(
LAST_NAME NVARCHAR(30),
FRST_NAME NVARCHAR(30))  

SELECT LAST_NAME,FRST_NAME INTO #TMPGUARDIAN  FROM TBL_PEOPLE

执行此操作时，我收到错误消息数据库中已存在名为‘#TMPGUARDIAN’的对象".谁能告诉我为什么我会收到这个错误?

When I do this I get an error 'There is already an object named '#TMPGUARDIAN' in the database'. Can anyone tell me why I am getting this error?

推荐答案

您正在删除它，然后创建它，然后尝试使用 SELECT INTO 再次创建它.更改为:

You are dropping it, then creating it, then trying to create it again by using SELECT INTO. Change to:

DROP TABLE #TMPGUARDIAN
CREATE TABLE #TMPGUARDIAN(
LAST_NAME NVARCHAR(30),
FRST_NAME NVARCHAR(30))  

INSERT INTO #TMPGUARDIAN 
SELECT LAST_NAME,FRST_NAME  
FROM TBL_PEOPLE

在 MS SQL Server 中，您可以使用 SELECT INTO

In MS SQL Server you can create a table without a CREATE TABLE statement by using SELECT INTO

这篇关于SQL Server 中的临时表导致“已经有一个名为的对象"错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！