1.要求插入自增id要先启用标识:SET IDENTITY_INSERT 表名 ON
2.语法为:
deliverAddress 为表名
SET IDENTITY_INSERT deliverAddress ON
INSERT INTO deliverAddress
(
id,
addressname ,
AccountNumber ,
IsBind
)
VALUES (
28 ,
'杭州仓库' , -- addressname - varchar(30)
'20932' , -- AccountNumber - varchar(10)
1 -- IsBind - bit
)
INSERT INTO deliverAddress
(
id,
addressname ,
AccountNumber ,
IsBind
)
VALUES ( 29,
'东圃分店' , -- addressname - varchar(30)
'20946' , -- AccountNumber - varchar(10)
1 -- IsBind - bit
)
SET IDENTITY_INSERT deliverAddress OFF
3.用完后要关闭 SET IDENTITY_INSERT 表名 OFF
4.启用标识只能用于新增,就是插入。