Wednesday, December 15, 2010

STR - for displaying the rounded decimal number

/* ROUND(expression,length )
* 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