Cannot insert explicit value for identity column in table 'Staff' when IDENTITY_INSERT is set to OFF.

Cannot insert explicit value for identity column in table 'Staff' when IDENTITY_INSERT is set to OFF.

SET IDENTITY_INSERT [Staff] ON
INSERT INTO [Staff]
([ID]
,[Sex]
,[FirstName]
,[LastName]
,[E_mail]
,[Email_Office]
,[PositionID]
,[AttendStart]
,[AttendEnd]
,[Title]
,[StaffNo]
,[CellPhone]
,[TelOffice]
,[TelNo]
,[Compound]
,[CompoundNo]
,[StreetNo]
,[District]
,[City]
,[PostCode]
,[Photo]
,[M1CardNo]
,[Barcode]
,[SalaryCategoryID]
,[SalaryCategoryLevelID]
,[SalaryModifiedDate]
,[SalaryModifiedBy]
,[Flag_UseComputerCalculateSalary]
,[SalaryCurrency]
,[Flag_CalculateSalaryUseSpecialWay]
,[WeekSalary]
,[WeekSalaryCurrency]
,[WeekHours]
,[ActualWeekhours]
,[SalaryMonthlyAddTitle]
,[SalaryMonthlyAdd]
,[SalaryMonthlyAddCurrency]
,[SalaryMonthlyMinusTitle]
,[SalaryMonthlyMinus]
,[SalaryMonthlyMinusCurrency]
,[AccountName]
,[AccountBankName]
,[AccountNoInGerman]
,[AccountBLZ]
,[AccountIBAN]
,[AccountSwift]
,[ArchivesNo]
,[SortNo]
,[Kurzel]
,[FlagShowInContactList]
,[UniqueNO]
,[Bus_StationId]
,[Birthday]
,[CampusID]
,[PrintCount]
,[ADAccount]
,[ADDisplayName]
,[Consultation]
,[IsADUpdate]
,[ADSID]
,[ADGUID]
,[Remark]
,[Tel_emergency]
,[Remark2]
,CreateDate
)
SELECT [ID]
,[Sex]
,[FirstName]
,[LastName]
,[E_mail]
,[Email_Office]
,[PositionID]
,[AttendStart]
,[AttendEnd]
,[Title]
,[StaffNo]
,[CellPhone]
,[TelOffice]
,[TelNo]
,[Compound]
,[CompoundNo]
,[StreetNo]
,[District]
,[City]
,[PostCode]
,[Photo]
,[M1CardNo]
,[Barcode]
,[SalaryCategoryID]
,[SalaryCategoryLevelID]
,[SalaryModifiedDate]
,[SalaryModifiedBy]
,[Flag_UseComputerCalculateSalary]
,[SalaryCurrency]
,[Flag_CalculateSalaryUseSpecialWay]
,[WeekSalary]
,[WeekSalaryCurrency]
,[WeekHours]
,[ActualWeekhours]
,[SalaryMonthlyAddTitle]
,[SalaryMonthlyAdd]
,[SalaryMonthlyAddCurrency]
,[SalaryMonthlyMinusTitle]
,[SalaryMonthlyMinus]
,[SalaryMonthlyMinusCurrency]
,[AccountName]
,[AccountBankName]
,[AccountNoInGerman]
,[AccountBLZ]
,[AccountIBAN]
,[AccountSwift]
,[ArchivesNo]
,[SortNo]
,[Kurzel]
,[FlagShowInContactList]
,[UniqueNO]
,[Bus_StationId]
,[Birthday]
,[CampusID]
,[PrintCount]
,[ADAccount]
,[ADDisplayName]
,[Consultation]
,[IsADUpdate]
,[ADSID]
,[ADGUID]
,[Remark]
,[Tel_emergency]
,[Remark2]
,CreateDate
FROM [Staff_Del_History] where id in (1,3)
SET IDENTITY_INSERT [Staff] OFF
相关阅读:
登陆的一个大概流程
 过滤器实现编码过滤处理
 注册的一个大概流程
 lstm clip
gemm c++
lstm的debug模式下编译不行貌似
 caffe编译关于imread问题的解决
 c++ 走向高级之日积月累
 c++ 线程
 InitGoogleLogging坑爹
原文地址：https://www.cnblogs.com/zyip/p/2495574.html