[sql server][基础] insert时如何给自增列赋值

--建立测试环境

IF OBJECT_ID('tb') IS NOT NULL  DROP TABLE tb

GO

CREATE TABLE tb

(

 id int identity,

 code varchar(10),

 name varchar(20),  

    CONSTRAINT PK_TB PRIMARY KEY (id)

)

GO

--查询

INSERT TB SELECT 'AA','AA'

insert tb values('bb','bb')

select * from tb

go

--结果

set IDENTITY_INSERT tb on

INSERT TB SELECT 3, 'AA','AA'

insert tb values(3,'bb','bb')

go

--结果

set IDENTITY_INSERT tb on

INSERT TB (id,code,name) SELECT 3, 'AA','AA'

insert tb (id,code,name) values(4,'bb','bb')

select * from tb

--结果