22,209
社区成员
发帖
与我相关
我的任务
分享
alter table b alter column a bigint
declare
@data bigint
select @data =(select sum(CONVERT(BIGINT,a) ) from b)
应该是你的A超过INT
declare
@data bigint
select @data =(select sum(cast(a as bigint)) from b)
declare
@data bigint
select @data =(select sum(cast(a as bigint)) from b)