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