我有一个表。仅一个自增长字段
CREATE TABLE [ChangeObjectInterface] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
CONSTRAINT [PK_ChangeObjectInterface] PRIMARY KEY CLUSTERED
(
[id]
) ON [PRIMARY]
) ON [PRIMARY]
GO
请问如何向他进行插入
CREATE TABLE [ChangeObjectInterface] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
CONSTRAINT [PK_ChangeObjectInterface] PRIMARY KEY CLUSTERED
(
[id]
) ON [PRIMARY]
) ON [PRIMARY]
GO
请问如何向他进行插入
VALUES(1)------------此句报错当 IDENTITY_INSERT 设置为 OFF 时,不能向
--表 'ChangeObjectInterface' 中的标识列插入显式值。
INSERT INTO [ChangeObjectInterface]([id])
VALUES(1)
set identity_insert ChangeObjectInterface off/*(所影响的行数为 1 行)*/
set identity_insert changeobjectinterface oninsert into [changeobjectinterface]([id]) values(1)set identity_insert changeobjectinterface off