我被要求将现有的表复制到另一台服务器,但在重新创建表后似乎无法直接插入。
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tblRadiologyData]
(
[RadiologyID] [int] IDENTITY(1,1) NOT NULL,
[ExaminationDate] [datetime] NOT NULL,
[ReferralDate] [datetime] NULL,
[ReportedDate] [datetime] NULL,
[AttendanceNumber] [varchar](10) NULL,
[LocalPatientIdentifier] [varchar](10) NOT NULL,
[NHSNumber] [varchar](10) NULL,
[Surname] [varchar](35) NULL,
[Forenames] [varchar](35) NULL,
[DateOfBirth] [datetime] NULL,
[AttendanceStatus] [varchar](20) NULL,
[AttendancePatientCategory] [varchar](10) NULL,
[AttendancePatientGroup] [varchar](20) NULL,
[AttendanceSpecialtyName] [varchar](50) NULL,
[AttendancePriority] [varchar](10) NULL,
[AttendanceSiteCode] [varchar](4) NULL,
[ExamExaminationCode] [varchar](10) NOT NULL,
[ExamRoomName] [varchar](50) NULL,
[ExamExaminationName] [varchar](30) NULL,
[ExamKornerCategory] [varchar](10) NULL,
[KornerBandName] [varchar](20) NULL,
[AttendanceSourceName] [varchar](30) NULL,
[RefDoctor] [varchar](30) NULL,
[DemogRegisteredGPCode] [varchar](8) NULL,
[RegPracCode] [varchar](10) NULL,
[Practice] [varchar](6) NULL,
[DOHCode] [varchar](8) NULL,
[PCOCode] [varchar](5) NULL,
[ExamDuration] [int] NULL,
[InternalNumber] [varchar](12) NULL,
[Postcode] [varchar](8) NULL,
[PCTRes] [varchar](5) NULL,
[DHA] [varchar](3) NULL,
[KornerBand] [varchar](2) NULL,
[OPUnbundled] [bit] NOT NULL,
[UB_HRG] [varchar](5) NULL,
[StatusCode] [varchar](2) NULL,
[LastModified] [datetime] NULL,
[SpecialtyCode] [varchar](3) NULL,
[deptcode] [varchar](255) NULL,
[HRGCode] [varchar](5) NULL,
[HRGGroup] [varchar](6) NULL,
[HRGTariff] [decimal](19, 4) NULL,
[Chargeable] [bit] NOT NULL,
[HEYActivity] [varchar](10) NULL,
[InternallyTraded] [varchar](3) NULL,
[PatientSex] [nchar](10) NULL,
[EthnicCategory] [nchar](10) NULL,
[AgeAtExamDate] [int] NULL,
[HRGCode1516] [varchar](5) NULL,
CONSTRAINT [PK_tblRadiologyData]
PRIMARY KEY NONCLUSTERED ([ExaminationDate] ASC,
[LocalPatientIdentifier] ASC,
[ExamExaminationCode] ASC)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,
IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON,
ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[tblRadiologyData]
ADD DEFAULT ((0)) FOR [OPUnbundled]
GO
ALTER TABLE [dbo].[tblRadiologyData]
ADD DEFAULT ((0)) FOR [Chargeable]
GO
上面是原始代码,我想做的是将其复制并重新创建到不同的服务器/数据库[CHH-BI].[CommDB]中。
我这样做了,并尝试从先前的表中全部插入到新表中,但出现以下错误:
Msg 8101, Level 16, State 1, Line 4 在未指定列名且IDENTITY_INSERT为ON时,无法为表'CommDB.dbo.tblRadiologyData'中的标识列指定显式值。
我是在走错了路还是遗漏了什么?我认为这只是一个简单的工作,从旧表复制所有内容到新表!