SET IDENTITY_INSERT [Table] [ON|OFF]
SET IDENTITY_INSERT [Table] ON 时表示暂时可以不用自增长可以收到插入数据,到不能有重复。需要特别注意的时,必须在insert into table 后边指定字段,或者会报"can only be specified when a column list is used and IDENTITY_INSERT is ON" ! SET IDENTITY_INSERT ...
复制链接