Round A Number In MS SQL

10th November 2008

To round a number in MS SQL use the ROUND() function. This function takes two parameters, the first is the number to be rounded and the second is the number of decimal places to round the number to. Here is an example of rounding the numbers in a column to the nearest whole integer.

Add new comment

The content of this field is kept private and will not be shown publicly.