TechNet
Export (0) Print
Expand All

SIN (Transact-SQL)

 

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2008)yesAzure SQL DatabaseyesAzure SQL Data Warehouse yesParallel Data Warehouse

Returns the trigonometric sine of the specified angle, in radians, and in an approximate numeric, float, expression.

Topic link icon Transact-SQL Syntax Conventions

  
SIN ( float_expression )  

-- Azure SQL Data Warehouse and Parallel Data Warehouse  
SIN (float_expression )  

float_expression
Is an expression of type float or of a type that can be implicitly converted to float.

float

The following example calculates the SIN for a specified angle.

DECLARE @angle float;  
SET @angle = 45.175643;  
SELECT 'The SIN of the angle is: ' + CONVERT(varchar,SIN(@angle));  
GO  

Here is the result set.

The SIN of the angle is: 0.929607                         
  
(1 row(s) affected)  

The following example calculates the sine for a specified angle.

SELECT SIN(45.175643);  

Here is the result set.

---------

0.929607

Mathematical Functions (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft