SQL SIGN Function

The SQL SIGN function is one of the SQL Mathematical function, which is used to return sign of the specified expression, and the sign maybe Positive (+1), Negative (-1) or Zero (0). In this article we will show you, How to use/write SQL Server SIGN function with example.

SQL SIGN Function Syntax

The basic syntax of the SQL Server SIGN Function is as shown below:

Numeric_Expression: This function accepts exact numeric, or an approximately numeric data types. Remember that, it will not accept the Bit data type.

• If the Numeric_Expression argument is positive or negative Zero, SIGN function will return Zero as result.
• If the Numeric_Expression argument is Negative Number, SIGN function will return Negative One(-1) as result.
• If the Numeric_Expression argument is positive Number, SIGN function will return Positive One(+1) as result.

SQL SIGN Function Example 1

The SQL server SIGN Function is used to convert user specified radians to an approximately equivalent angle in degrees. In this example, We are going to find the degrees of different data (positive and negative values) and display the output

T-SQL CODE

OUTPUT

ANALYSIS

Below lines of code is used to declare float variable and assigning the random value.

Next, we are finding the Sign of @i. We used the SQL ALIAS Column to assign new name to the result as ‘Sign Result 1’.

In the below statement, We used SIGN function directly on the positive values.

Next, We used SIGN function on positive and negative zero

Next, We used SIGN function directly on the negative values

SQL SIGN Function Example 2

In this example, We are going to find the sign of all the records present in the [Service Grade] column using DEGREES Function.

T-SQL CODE

OUTPUT

Thank You for Visiting Our Blog