SQL Server-数据库中强varchar类型使用sum函数计算总和

 

select sum(cast(totalmoney AS DECIMAL)) as totalmoney from dbo.t_wxbill