Does the decimal scale value replace rounding in SQL Server?

Asked Feb 01 '20 at 10:24

Active Feb 01 '20 at 10:50

Viewed 66 times

Considering this code:

DECLARE @Price AS DECIMAL(25,10) = 1231234.9898989142

DECLARE @TABLE AS TABLE 
                  (
                        Number DECIMAL(19,4)
                  )

INSERT INTO @TABLE 
VALUES (@Price)

SELECT * 
FROM @TABLE

SELECT ROUND(@Price, 4)

Can we count on the column decimal scale value to always round the number or should we use the ROUND() function to round the number before inserting into the table?

edited Feb 01 '20 at 10:50

marc_s

732,580
175
1,330
1,459

asked Feb 01 '20 at 10:24

Pierre Younes

If you are looking for 1231234.9898 as answer, try this - SELECT cast(round(@Price,4,1) as decimal(19,4)) – Arulmouzhi Feb 01 '20 at 10:55
Thank you guys for your answers, what i mean exactly, why use Round() while the column type take care of this for you. – Pierre Younes Feb 01 '20 at 11:48
@PierreYounes Have you visited the link? – GSerg Feb 01 '20 at 12:05
@GSerg Yes i did, Thanks – Pierre Younes Feb 03 '20 at 08:19

Does the decimal scale value replace rounding in SQL Server?

0 Answers0