/* ROUND(expression,length )
* It can only contain the maximum range of decimal value
* Eg: 9223372.14554 -> 9223372.15
**********************************************************/* It can only contain the maximum range of decimal value
* Eg: 9223372.14554 -> 9223372.15
DECLARE @Number FLOAT
SET @Number = 92233720.14554
SELECT ROUND(@Number,2)
No comments:
Post a Comment