Kommentar
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Returns a numeric expression that is rounded to the specified length or precision. The length parameter must evaluate to an integer.
Syntax
ROUND(numeric_expression,length)
Arguments
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.
Result Types
The same type as numeric_expression.
Remarks
The length argument must evaluate to a positive integer or zero.
ROUND returns a null result if the argument is null.
Expression Examples
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)