27,579
社区成员
发帖
与我相关
我的任务
分享
DECLARE @t TABLE ( v float)
INSERT INTO @t
SELECT 49.2
UNION ALL SELECT 51.3
UNION ALL SELECT 210.5
UNION ALL SELECT 289.8
SELECT v,(CAST(v AS INT)+50)/50*50 AS convertV FROM @t
/*
v convertV
---------------------- -----------
49.2 50
51.3 100
210.5 250
289.8 300
*/
试下这个呢?DECLARE @t TABLE ( v INT)
INSERT INTO @t
SELECT 49
UNION ALL SELECT 51
UNION ALL SELECT 210
UNION ALL SELECT 289
SELECT (v+50)/50*50 AS v FROM @t
/*
v
50
100
250
300
*/