需要特别注意的时,必须在insert into table 后边指定字段,或者会报"can only be specified when a column list is used and IDENTITY_INSERT is ON" !
SET IDENTITY_INSERT [Table] OFF时表示恢复自增长。