Rounding of SQL Server values

Rounding in SQL usually has two ways: round and cast (... as decimal ()).

The personal advice is to use the cast method:

Mode 1:

After testing, the same can be rounded, but round the following example 1 will be an error,

Example 1:select round (0.996123,2) Error: arithmetic overflow errors when converting expression to data type numeric.

Example 2:select round (0.99432,2) results are 0.99000

Mode 2:

Cast Rounding:

SELECT CAST('123.456'  as decimal( -,2))===>123.46SELECT CAST(0.996123  as DECIMAL( -,2)) results are1.00SELECT  CAST('123.456'  as Dec( -,2))===>123.46

Rounding of SQL Server values