Skip to content

SIN() and COS() Function in SQL Server

SIGN() Function in SQL Server

Last Updated : 27 Sep, 2024

In SQL Server, the SIGN() function is a mathematical function used to determine the sign of a given numeric expression. This function is particularly useful when we want to evaluate whether a number is positive, negative or zero. In this article, We will learn about SIGN() Function in SQL Server in detail by understanding various examples

SIGN() Function in SQL Server

The SIGN() function in SQL Server is used to return the sign of a given numeric expression.
It indicates whether the number is positive, negative or zero by returning 1, -1 or 0 respectively.

Features of SIGN() Function in SQL Server

This function is used to find the sign of the given number i.e., that given number is positive or negative or zero.
This function accepts only all types of numbers i.e., positive, negative, zero.
This function also accepts fraction numbers.
This function always returns 1 if the number is positive, -1 if the number is negative and 0 for zero number.

Syntax:

SIGN(number)

Parameter:

This method accepts a parameter as given below :

number: Specified number to return the sign for.

Returns:

It returns the sign of the specified number.

Examples of SIGN() Function in SQL Server

Example 1:

Getting the result as 1 i.e., positive for the specified number 2.

SELECT SIGN(2);

Output:

Example 2:

Getting the result as -1 i.e., negative for the specified number -7.

SELECT SIGN(-7);

Output:

-1

Example 3:

Let’s Determine the sign of a numeric variable in SQL Server that holds the value 0 using the SIGN() function.

DECLARE @Parameter_Value INT;
SET @Parameter_Value = 0;
SELECT SIGN(@Parameter_Value);

Output:

Explanation: In this query, a variable @Parameter_Value is declared as an integer and assigned a value of 0. The SIGN() function is then used to evaluate the sign of this variable. Since the value is 0, the SIGN() function will return 0, indicating that the number is neither positive nor negative.

Example 4:

Getting the result as 1 i.e., positive for the result of “5/2”.

SELECT SIGN(5/2);

Output:

Example 5:

Using SIGN() function with a variable and getting the result as 1 i.e., positive for the float value “5.75”.

DECLARE @Parameter_Value FLOAT;
SET @Parameter_Value = 5.75;
SELECT SIGN(@Parameter_Value);

Output:

1.0

Conclusion

The SIGN() function in SQL Server provides a simple yet powerful way to determine the sign of any numeric value, whether it’s positive, negative, or zero. This function is versatile and works with all numeric types, making it ideal for scenarios where you need to quickly evaluate or categorize numbers in SQL queries.

SIN() and COS() Function in SQL Server

K

Kanchan_Ray

Improve

Article Tags :

Similar Reads

SOUNDEX() Function in SQL Server

The SOUNDEX() function in SQL Server is a powerful tool for handling phonetic matching, which allows you to compare words based on their sound rather than their exact spelling. This can be particularly useful in applications like searching and data cleansing where names or words may have different s

SIN() and COS() Function in SQL Server

1. SIN() Function : The SIN() function returns the sine of a number. Syntax : SIN(number) Parameter : Required. A numeric value. number : It is a numeric value. Returns : It returns the float_expression of the sine of a number. Example-1 : When the argument holds a positive number. SELECT SIN(5); Ou

SQRT() Function in SQL Server

SQRT() function : This function in SQL Server is used to return the square root of a specified positive number. For example, if the specified number is 81, this function will return 9. Features : This function is used to find the square root of a given number. This function accepts only positive num

SQL Server LEN() Function

SQL SERVER LEN() function calculates the number of characters of an input string, excluding the trailing spaces. LEN() Function in SQL ServerThe LEN function in the SQL Server fetches the number of characters in a string. It counts the preceding spaces but not the trailing spaces. For eg, 'SQL SERVE

LOG() Function in SQL Server

The LOG() function returns the logarithm of a specified number or the logarithm of the number to the specified base. Syntax : LOG(number, base) Parameter : LOG() function accepts two-parameters as mentioned above and described below. number - This parameter hold a number which is greater than 0. bas

DAY() Function in SQL Server

DAY() function : This function in SQL Server is used to return the day of the month i.e, from 1st to 31st for date stated. Features : This function is used to find the day of the month for a date specified. This function comes under Date Functions. This function accepts only one parameter i.e, date.

STR() Function in SQL Server

The STR() function converts a numeric value to a character value. Syntax : STR(float_expression [, length [, decimal]]) Parameter : This method accepts three parameters as mentioned above and described below : float_expression : It is a numeric expression that evaluates to an approximate number with

SUM() Function in SQL Server

The SUM() function in SQL Server is an essential aggregate function used to calculate the total sum of values in a numeric column. It aggregates data by summing up all values in the specified column for the rows that match the criteria of the query. In this article, We will learn about SUM() Functio

SQL Server ISNULL() Function

The ISNULL() function in SQL Server is a powerful tool for handling NULL values in our database queries. It allows us to replace NULL values with a specified replacement value, ensuring that your queries return meaningful results even when data is missing. In this article, We will learn about the SQ

IIF() Function in SQL Server

IIF() function judges or evaluates the first parameter and returns the second parameter if the first parameter is true, otherwise, it returns the third parameter. IIF() function used in SQL Server to add if-else logic to queries.IIF is not supported in dedicated SQL pools in Azure Synapse Analytics.