数据库mssql数字格式与字符格式转换

来源:互联网 发布:我的体育老师 知乎 编辑:程序博客网 时间:2024/04/30 04:23
set MarketPrice =cast(cast(t.SalesPrice *@MarketPriceMin/100 as numeric(18,2)) as varchar(32))+ '~' + cast(cast(t.SalesPrice *@MarketPriceMax/100 as numeric(18,2)) as varchar(32)),

0 0