select t.totalprice*(select cast(s.value as decimal(3,2)) from sys_param s where s.name='积分') as info from trade_info t
在做查询乘法运算的时候,碰到了varchar跟int相乘变成字符串拼接的问题,
通过cast(value as type),将varchar转为decimal解决了此问题
select t.totalprice*(select cast(s.value as decimal(3,2)) from sys_param s where s.name='积分') as info from trade_info t
在做查询乘法运算的时候,碰到了varchar跟int相乘变成字符串拼接的问题,
通过cast(value as type),将varchar转为decimal解决了此问题