select convert( varchar(90),power(2,31))Msg 232, Level 16, State 3, Line 1
Arithmetic overflow error for type int, value = 2147483648.000000.如何解决? 如果求 power(200,2000) 呢? 多谢!
Arithmetic overflow error for type int, value = 2147483648.000000.如何解决? 如果求 power(200,2000) 呢? 多谢!
SELECT CONVERT(VARCHAR(90),POWER(2.00,31))
select convert( varchar(90),power(cast(2 as bigint),62))select convert(varchar(90),power(cast(2 as numeric),126))select convert(varchar(90),power(cast(2 as float),1023))
每种类型都有个范围,power(200,2000) 估计算不出来……