SIGN() Examples in SQL Server

In SQL Server, the T-SQL SIGN() function returns the sign of a number. In other words, it indicates whether or not the value is a positive number, a negative number, or zero.

You provide the number as an argument when calling the function.

The function returns the following result, depending on whether the argument is positive, negative, or zero.

  • 1 if the number is positive
  • -1 if the number is negative
  • 0 if the number is zero

Continue reading

ROUND() Examples in SQL Server

In SQL Server, the T-SQL ROUND() function allows you to round a number to a specified length or precision.

You provide the number as an argument, as well as the length you’d like the number to be rounded to. The function also accepts an optional third argument that allows you to specify whether the number is rounded or truncated.

Continue reading

POWER() Examples in SQL Server

In SQL Server, the T-SQL POWER() function is a mathematical function that returns the value of the specified expression to the specified power.

The function accepts two arguments; the first specifies the expression, the second specifies the power with which to raise that expression.

The return value is the same data type as the first argument.

Continue reading