0 out of 2 rated this helpful - Rate this topic

ROUND (SSIS)

SQL Server 2005

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


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.

ROUND(137.1574,3)
ROUND(137.1575,3)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions