Mega Code Archive

 

Categories / MSSQL / Math Functions

 

ROUND

2> -- ROUND: Rounds a value to the number of decimal places specified in the second parameter. 3> 4> -- ROUND(number_to_round, number_ of_places,[0|1]) 5> 6> SELECT ROUND(100.345678,5,0) 7> GO -----------  100.345680 (1 rows affected)