22,210
社区成员
发帖
与我相关
我的任务
分享
declare @F table (Price numeric(10,4))
insert into @F
select 123243.2324 union all
select 3243.2354 union all
select 22.2344
select CAST(Price AS DECIMAL(18,2)) AS Price from @F
/*
Price
---------------------------------------
123243.23
3243.24
22.23
*/
declare @F table (Price numeric(10,4))
insert into @F
select 123243.2324 union all
select 3243.2354 union all
select 22.2344
select CAST(Price AS DECIMAL(18,2)) AS Price from @F
/*
Price
---------------------------------------
123243.23
3243.24
22.23
*/