insert into Person_Info(列名1,列名2) values('data1','data2')
当设置主键为自动增长是,不能为他进行插入值,如果这样做就会报你说的那个错误的insert into Person_Info values('data1','data2') 就可以了
1. insert into Person_Info(列名1,列名2) values('data1','data2')2. SET IDENTITY_INSERT Person_Info ON go insert into Person_Info values(非空值,'data1','data2') go SET IDENTITY_INSERT Person_Info OFF go
insert into Person_Info values('data1','data2') 自增列不需要插入.................. 系统自动生成
自增列不需要插入.................. 系统自动生成 INSERT INTO Person_Info(列名2,列名3) values('data1','data2')
就可以了
insert into Person_Info(列名1,列名2) values('data1','data2')2.
SET IDENTITY_INSERT Person_Info ON
go
insert into Person_Info values(非空值,'data1','data2')
go
SET IDENTITY_INSERT Person_Info OFF
go
自增列不需要插入..................
系统自动生成
系统自动生成
INSERT INTO Person_Info(列名2,列名3) values('data1','data2')
除非设置set identity_insert table_name on才可以
至于表列不固定,那么写动态SQL来实现,这个也不难