阅读背景:

临时表的主键已经存在

来源:互联网 

I have the following query

我有以下查询。

declare @var1 int, @var2 int
set @var1 = 110
set @var2 = 300

IF object_id('tempdb..#tbl_Contract') IS NOT NULL
BEGIN
   ALTER TABLE #tbl_Contract drop constraint PK_#tbl_Contract
   DROP TABLE #tbl_Contract
END

CREATE TABLE #tbl_Contract
(  ContractID int NOT NULL
,  PersonID int NOT NULL
,  EndDate smalldatetime NULL
,  CONSTRAINT [PK_#tbl_Contract] PRIMARY KEY CLUSTERED 
   (
     ContractID ASC
   )
)
...
declare 



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: