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)),
数据库mssql数字格式与字符格式转换
最新推荐文章于 2022-06-02 16:34:16 发布
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)),