请教各位大大,以下这段code 我放在tempdb中可以多次运行无问题,但放在northwind中却只能运行一次,这是怎么回事?因为我在用delphi中的ADOConnection连接的是northwind

IF EXISTS (SELECT *
FROM dbo.sysobjects
WHERE id = object_id(N'[dbo].[#a]') AND OBJECTPROPERTY(id, N'IsUserTable')
= 1) DROP TABLE [dbo].[#a]
SELECT *
INTO #a
FROM northwind.dbo.Orders

IF (SELECT OBJECT_ID('tempdb..#a')) IS NOT NULL BEGIN DROP TABLE #a END
SELECT *
INTO #a
FROM northwind.dbo.Orders