sql - varchar 值的转换溢出了 int 列

Question

对于@nReservationID的某些值:

SELECT @phoneNumber=
  CASE 
    WHEN  ISNULL(rdg2.nPhoneNumber  ,0) = 0 THEN ISNULL(rdg2.nMobileNumber, 0)
    ELSE ISNULL(rdg2.nPhoneNumber  ,0)
  END 
from tblReservation_Details_Guest  rdg2 
where nReservationID=@nReservationID

为什么我会收到此错误？

Msg 248, Level 16, State 1, Procedure USP_CRE_WEB_MEMBER_AUTOGENERATEDECV, Line 136 The conversion of the varchar value '08041159620' overflowed an int column.

Answer 1

Declare @phoneNumber int

select @phoneNumber=Isnull('08041159620',0);

给出错误:

The conversion of the varchar value '8041159620' overflowed an int column.: select cast('8041159620' as int)

AS

整数定义为:

从 -2^31 (-2,147,483,648) 到 2^31 - 1 (2,147,483,647) 的整数(整数)数据。存储大小为4字节。 int 的 SQL-92 同义词是整数。

解决方案

Declare @phoneNumber bigint

Reference