Home Library Learn Samples Downloads Support Community Forums
This topic has not yet been rated - Rate this topic

ROUND (SSIS Expressions)

SQL Server 2008

Returns a numeric expression that is rounded to the specified length or precision. The length parameter must evaluate to an integer.

Copy 

ROUND(numeric_expression,length)
numeric_expression

Is an expression of a valid numeric type. For more information, see Integration Services Data Types.

length

Is an integer expression. It is the precision to which numeric_expression is rounded.

The same type as numeric_expression.

The length argument must evaluate to a positive integer or zero.

ROUND returns a null result if the argument is null.

These examples round numeric literals to a length of three. The first return result is 137.1570, the second 137.1580.

Copy 
ROUND(137.1574,3)
ROUND(137.1575,3)
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.