CREATE TABLE [dbo].[xxxLog](
[log_id] [bigint] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[log_image] [char](1) NOT NULL,
[log_instant] [datetime] NOT NULL,
[bra_num] [varchar](20) NOT NULL,
[bra_parent] [varchar](20) NOT NULL,
[bra_level] [int] NOT NULL,
[bra_desc] [varchar](50) NOT NULL,
[bra_longnum] [varchar](200) NOT NULL,
[bra_stat] [char](1) NOT NULL,
[bra_updatetime] [datetime] NOT NULL,
[log_updateuser] [char](16) NULL,
CONSTRAINT [PK_xxxLog] PRIMARY KEY CLUSTERED
(
[log_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]Insert into xxxLog select * from abc.test.DBO.xxxLog 出现:Msg 8101, Level 16, State 1, Line 21
An explicit value for the identity column in table 'xxxLog' can only be specified when a column list is used and IDENTITY_INSERT is ON.请问上述是什么原因引起的呢,谢谢!
[log_id] [bigint] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[log_image] [char](1) NOT NULL,
[log_instant] [datetime] NOT NULL,
[bra_num] [varchar](20) NOT NULL,
[bra_parent] [varchar](20) NOT NULL,
[bra_level] [int] NOT NULL,
[bra_desc] [varchar](50) NOT NULL,
[bra_longnum] [varchar](200) NOT NULL,
[bra_stat] [char](1) NOT NULL,
[bra_updatetime] [datetime] NOT NULL,
[log_updateuser] [char](16) NULL,
CONSTRAINT [PK_xxxLog] PRIMARY KEY CLUSTERED
(
[log_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]Insert into xxxLog select * from abc.test.DBO.xxxLog 出现:Msg 8101, Level 16, State 1, Line 21
An explicit value for the identity column in table 'xxxLog' can only be specified when a column list is used and IDENTITY_INSERT is ON.请问上述是什么原因引起的呢,谢谢!
谢谢,不过加入上述sql,再执行也还有上述错误阿
Insert into xxxLog(列1,列2...列n) select * from abc.test.DBO.xxxLog
Insert into xxxLog select * from abc.test.DBO.xxxLog
SET IDENTITY_INSERT xxxLog OFF你有自增列不能显示插入的,
要不然你显示指定列吧,