四舍五入怎么取整50和整百

[ajdkjalj]

有个字段要求四舍五入，1到49取50,51到99取整百，比如210取250,289取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
*/

[ajdkjalj]

引用 1 楼 yenange 的回复:

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
*/

还在没啊，有点小问题，

i.cInvDefine12是int类型，i.cInvDefine13 是float类型，得出来结果不正确呢

[吉普赛的歌]

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
*/

试下这个呢？