报错信息 Msg 8101, Level 16, State 1, Line 4
An explicit value for the identity column in table 'dbo.Vendors' can only be specified when a column list is used and IDENTITY_INSERT is ON.
表结构
CREATE TABLE [dbo].[Vendors](
[Id] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[Name] [nvarchar](100) NOT NULL,
[EnglishName] [nvarchar](50) NOT NULL,
[Alias] [nvarchar](20) NULL,
[WorkLocation] [nvarchar](20) NOT NULL,
[Property] [nvarchar](50) NULL,
[Department] [nvarchar](50) NULL,
[IsNew] [nchar](1) NOT NULL,
[Title] [nvarchar](50) NULL,
[Report_To] [nvarchar](50) NULL,
[Serving] [nvarchar](50) NULL,
CONSTRAINT [PK_ChinaSoftVendors_1] PRIMARY KEY CLUSTERED
(
[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]GO
插入语句就是普通的 insert
An explicit value for the identity column in table 'dbo.Vendors' can only be specified when a column list is used and IDENTITY_INSERT is ON.
表结构
CREATE TABLE [dbo].[Vendors](
[Id] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[Name] [nvarchar](100) NOT NULL,
[EnglishName] [nvarchar](50) NOT NULL,
[Alias] [nvarchar](20) NULL,
[WorkLocation] [nvarchar](20) NOT NULL,
[Property] [nvarchar](50) NULL,
[Department] [nvarchar](50) NULL,
[IsNew] [nchar](1) NOT NULL,
[Title] [nvarchar](50) NULL,
[Report_To] [nvarchar](50) NULL,
[Serving] [nvarchar](50) NULL,
CONSTRAINT [PK_ChinaSoftVendors_1] PRIMARY KEY CLUSTERED
(
[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]GO
插入语句就是普通的 insert
解决方案 »
- 送分,当然还是要先回答问题的。
- 写个什么SQL语句能实现如下的数据结构
- 原料分类,添加很多级分类的数据库要设计呢
- window server2003企业版的操作系统,安装SQL SERVER2003的数据库怎么不好用啊,听说要装什么插件的,那位大哥知道帮小弟一把!!!!!
- 怪!!!求高手:SQL Server数据库所在盘如果没空间了,应用程序还正常运转,数据存哪?
- 一列的数据怎样插入到另一个表行中?
- 新手请教:这个触发器怎么写?
- (转帖100分)怎么我的Sql会变成选择全部记录的?
- 请大家看看,能不能帮我一下!我给高分!
- SQL导出EXCEL出现问题!请高手相助!!!!!
- 怎么创建视图
- SQL 语句优化,求大神
把这个去掉
比如原来的
isnert into Vendors values(1,'name'...)
改成isnert into Vendors values('name'...)
An explicit value for the identity column in table 'dbo.Vendors' can only be specified when a column list is used and IDENTITY_INSERT is ON.他说,如果你想显示插入自增列,需要将IDENTITY_INSERT设为ONSET IDENTITY_INSERT [dbo].[SearchKey] ON--你的插入语句SET IDENTITY_INSERT [dbo].[SearchKey] OFF
再执行你的插入语句
SET IDENTITY_INSERT [dbo].[Vendors] OFF
SET IDENTITY_INSERT [dbo].[Vendors] ON
insert into [dbo].[ChinaSoftVendors]
values(263,'a','a','a','a','a','a','1','a','a','a')
SET IDENTITY_INSERT [dbo].[Vendors] OFF
还是会报错,这个我昨天就试了,我怀疑是自增列的本身数据有问题,因为数据不连续了(自增列数据不连续),用了4楼的方法可行。