数据表ID自增长另外定义了一个主键，向数据库插入一条数据报错，提示主键冲突

Question

sql _:insert into POS_SaleMaster (companyID,billNo,shopID,billDate,billTime,vipID,cashierID,personnelID,payMethod,payAmount,cashAmount,bankCardAmount,changeAmount,vIPIntegral,billStatus,finished,checkDate,promotionID,printDegree,roundDigitNum,otherAmount,otherAmountPresend,dischargeIntegralAmount,dischargeIntegral) values ( 'UR','UR006616063000037','UR000057','2016-06-30 19:05:56','2016-06-30 19:05:56','8urP0282105','051405024','051405024','6','237','0','237','0','237','4','0','2016-06-30 19:05:56','38','0','0','0','0','0','0' ) 19:05:55,786 ERROR stderr com.microsoft.sqlserver.jdbc.SQLServerException: 违反了 PRIMARY KEY 约束“PK_POS_SaleMaster”。不能在对象“dbo.POS_SaleMaster”中插入重复键。重复键值为 (UR013616063000024)。 19:05:55,786 ERROR stderr

Answer 1

自增长的不要设置，让它自己插入，主键要确保不能重复。