set IDENTITY_INSERT a off insert into a values(1,'zhou')
表a的id是自动增加的,插入时插不进去。我想把它设置一下 然后插进去一组数
set IDENTITY_INSERT a on go insert into a values(1,'zhou')
--测试环境 IF OBJECT_ID('dbo.tb') IS NOT NULL DROP TABLE tb GO CREATE TABLE tb (id INT IDENTITY(1,1) ,salary MONEY ) GO --测试SQL SET IDENTITY_INSERT tb ON GO INSERT INTO tb (id,salary) VALUES (144,3) SELECT * FROM tb --测试结果 /* id salary ----------- --------------------- 144 3.00(1 行受影响) */
insert into a(column1,column2) values(1,'zhou') 这里要加上列名
????
insert into a values(1,'zhou')
go
insert into a values(1,'zhou')
IF OBJECT_ID('dbo.tb') IS NOT NULL
DROP TABLE tb
GO
CREATE TABLE tb
(id INT IDENTITY(1,1) ,salary MONEY )
GO
--测试SQL
SET IDENTITY_INSERT tb ON
GO
INSERT INTO tb
(id,salary)
VALUES (144,3)
SELECT * FROM tb --测试结果
/*
id salary
----------- ---------------------
144 3.00(1 行受影响)
*/
这里要加上列名