select (192*255*255*255)+(168*255*255)+(0*255)+42将 expression 转换为数据类型 int 时发生算术溢出错误。

[kiss001]

select (192*255*255*255)+(168*255*255)+(0*255)+42将 expression 转换为数据类型 int 时发生算术溢出错误。

sql语句怎么计算大数阿

[lxzm1001]

也许你产生的数太多了啊你不要用int

[zyg0]

select cast(192 as bigint)*cast(255 as bigint)*cast(255 as bigint)*cast(255 as bigint)+
cast(168 as bigint)*cast(255 as bigint)*cast(255 as bigint)+cast(0 as bigint)*cast(255 as bigint)+cast(42 as bigint)

[zyg0]

默认是int类型，要是想运算必须指定每一个数的类型

[churchatp1]

select (cast(192*255 as bigint)*255*255)+(168*255*255)+(0*255)+42

[churchatp1]

只需要加一个cast就可以了，这样后面的自动会转换为bigint

[点点星灯]

select convert(bigint,255*255*255)*192+(168*255*255)+(0*255)+42

[vivianfdlpw]

declare @i bigint
set @i=255
select (192*@i*255*255)+(168*@i*255)+(0*@i)+42