速求一个insert 语句
我有一个表。仅一个自增长字段
CREATE TABLE [ChangeObjectInterface] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
CONSTRAINT [PK_ChangeObjectInterface] PRIMARY KEY CLUSTERED
(
[id]
) ON [PRIMARY]
) ON [PRIMARY]
GO
请问如何向他进行插入
[解决办法]
set identity_insert ChangeObjectInterface on
INSERT INTO [ChangeObjectInterface]([id])
VALUES(1)
set identity_insert ChangeObjectInterface off
/*
（所影响的行数为 1 行）
*/
[解决办法]
关注
[解决办法]
--允许将显式值插入表的标识列中。
set identity_insert changeobjectinterface on
insert into [changeobjectinterface]([id]) values(1)
set identity_insert changeobjectinterface off
