sqlserver显示插入自增值

CREATE TABLE table_name (id int IDENTITY PRIMARY KEY, product varchar(40));
SET IDENTITY_INSERT table_name ON;
INSERT INTO table_name (id , product) VALUES(1, 'garden shovel');

SET IDENTITY_INSERT不能同时设置两张表为on；如果要给另一个表设置on需要先将前一张表设置为off；

CREATE TABLE table_name1 (id int IDENTITY PRIMARY KEY, product varchar(40));
SET IDENTITY_INSERT table_name OFF;
SET IDENTITY_INSERT table_name ON;

使用后将表SET IDENTITY_INSERT设置为off，否则再次插入时，不能自增