创建表:
create table T
(
id int identity(1,1) not null,
name varchar(20)
)
向表中插入数据(ID为自增字段):
INSERT INTO T(ID,NAME) VALUES(1,'S')
报错信息如下:
执行脚本:
SET IDENTITY_INSERT T ON
再进行插入:
INSERT INTO T(ID,NAME) VALUES(1,'S')————插入成功!
执行脚本:
SET IDENTITY_INSERT T OFF
插入数据:
INSERT INTO T(NAME) VALUES('SS')
查询数据:
SELECT * FROM T
ID NAME
1S
2 SS
注:数据插入后要将 IDENTITY_INSERT重新设置为OFF
查看当前值和增量值:
SELECT IDENT_CURRENT('T') AS CUR,IDENT_INCR('T') AS INC