The SQL COS function is one of the Mathematical Function which is used to calculate the trigonometry Cosine for the specified expression. The mathematical formula for this function is:
COS(x) = Length of the Adjacent Side / Length of the Hypotenuse
SQL COS Function Syntax
In SQL Server, The basic syntax of the COS Function is:
|
1 2 |
SELECT COS (Float_Expression) FROM [Source] |
In this article we will show you, How to write COS Function in SQL Server 2014 with example. For this, We are going to use the below shown data
SQL COS Function Example 1
The SQL server COS Function is used to calculate the Cosine for given angle. The following query will show multiple ways to use COS function.
T-SQL CODE
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
DECLARE @i float SET @i = 208.45 SELECT COS(@i)AS [SQL Cosine] -- Calculating COS directly SELECT COS(0.24)AS [SQL Cosine] -- Calculating COS directly SELECT COS(0)AS [SQL Cosine] -- Calculating COS directly SELECT COS(1)AS [SQL Cosine] |
OUTPUT
ANALYSIS
Below lines of code is used to declare float variable and assigning the value.
|
1 2 |
DECLARE @i float SET @i = 208.45 |
In the below statement, We used COS function to calculate the Cosine value for the variable @i (It means COS(208.45)). We also assigned new name to that result as ‘SQL Cosine’ using SQL ALIAS Column.
|
1 |
SELECT COS(@i)AS [SQL Cosine] |
In the next statements, We used the COS Function directly on the float values.
SQL COS Function Example 2
In this example, We are going to calculate the Cosine value for all the records present in [Tax Amount] and [Service Grade] using COS Function.
T-SQL CODE
|
1 2 3 4 5 6 7 |
SELECT [EnglishProductName] ,[SalesAmount] ,[TaxAmt] ,COS([TaxAmt]) AS [Tax Cosine] ,[Service Grade] AS Grade ,COS ([Service Grade]) AS [Cosine] FROM [Mathemetical Functions] |
OUTPUT
Thank You for Visiting Our Blog
Leave a Reply