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
相关阅读:
最小最大数
 ubuntu14.04在虚拟环境中安装flask遇到的问题
 线性时间排序
 NSURLSession详细介绍，以及一些坑位的介绍
 IOS笔记本地化多语言支持
 Documenting in Xcode with HeaderDoc Tutorial
高效使用你的Xcode
Xcode 7遇到 App Transport Security has blocked a cleartext HTTP 错误
 iOS bug解决方案（02）
CGRect 的使用
原文地址：https://www.cnblogs.com/zyip/p/2495574.html