varchar值的转换溢出了int列

谢谢拉维和其他用户....尽管如此，我已经找到了解决方案

SELECt @phoneNumber=CASE   WHEN  ISNULL(rdg2.nPhoneNumber  ,'0') in ('0','-',NULL)THEN ISNULL(rdg2.nMobileNumber, '0')   WHEN ISNULL(rdg2.nMobileNumber, '0')  in ('0','-',NULL)THEN '0'  ELSE ISNULL(rdg2.nPhoneNumber  ,'0')END FROM tblReservation_Details_Guest  rdg2 WHERe nReservationID=@nReservationID

只需输入“ 0”而不是0