SQL Server Numeric Functions

ABS Function

The ABS function returns the absolute (non-negative) value of a numeric expression.

It is useful when you need to ensure a positive number regardless of the input sign.

CEILING and FLOOR Functions

CEILING returns the smallest integer greater than or equal to the input number.

FLOOR returns the largest integer less than or equal to the input number.

These functions are helpful for rounding numbers up or down to the nearest integer.

ROUND Function

ROUND allows you to round a numeric value to a specified number of decimal places.

You can also use it to truncate numbers by specifying a negative length.

POWER and SQRT Functions

POWER raises a base number to the exponent you specify.

SQRT returns the square root of a number, useful in mathematical calculations.

Using ABS to Get Absolute Values

Suppose you have a table with positive and negative numbers, and you want to get their absolute values.

Rounding Numbers with ROUND

You can round prices or measurements to a desired decimal place using ROUND.