在SQL语句里面如何将字符型转换成数字型sql字符串转数字 用cast(金额asdecimal(10,4))或者convert(decimal(10,4),金额)SELECT2023,sum(convert(decimal(10,4),[paymoney]))FROM[IMS_PUB_1].[dbo].[A]--whereSalaryMonthlike'2015.%'unionallSELECT2015,sum(convert(decimal(10,4),[paymoney]))FROM[IMS_PUB_1].[dbo].[A]whereSalaryMonthlike'2015.%'union

在SQL语句里面如何将字符型转换成数字型sql字符串转数字 用cast(金额asdecimal(10,4))或者convert(decimal(10,4),金额)SELECT2023,sum(convert(decimal(10,4),[paymoney]))FROM[IMS_PUB_1].[dbo].[A]--whereSalaryMonthlike'2015.%'unionallSELECT2015,sum(convert(decimal(10,4),[paymoney]))FROM[IMS_PUB_1].[dbo].[A]whereSalaryMonthlike'2015.%'union