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);

Output :

-0.95892427466313845

Example-2 :
When the argument holds a negative number.

SELECT SIN(-5);

Output :

0.95892427466313845

Example-3 :
When the PI() function is the argument.

SELECT SIN(PI());

Output :

1.2246467991473532E-16

Example-4 :
When the argument passed is an expression.

SELECT SIN(4 * 3);

Output :

-0.53657291800043494

2. COS() Function
The COS() function returns the cosine of a number.

Syntax :

COS(number)

Parameter : Required. A numeric value.
number : It is a numeric value.
Returns : It returns the cosine of a number.

Example-1 :
When the argument holds a positive number.

SELECT COS(4);

Output :

-0.65364362086361194

Example-2 :
When the argument is a fractional component.

SELECT COS(2.53);

Output :

-0.81873459927738157

Example-3 :
When the PI() function is the argument.

SELECT COS(PI());

Output :

-1