Export (0) Print
Expand All

ASIN

SQL Server 2000

Returns the angle, in radians, whose sine is the given float expression (also called arcsine).

Syntax
ASIN ( float_expression ) 
Arguments
float_expression
Is an expression of the type float, or of types that can be implicitly converted to float, with a value from -1 through 1. Values outside this range report a domain error.
Return Types

float

Examples

The following example returns the arcsine of the sine of various angles.

CREATE TABLE Asine ("SIN(0)" float, "SIN(PI()/6)" float, "SIN(PI()/4)" float, "SIN(PI()/3)" float, "SIN(PI()/2)" float)
INSERT INTO Asine VALUES (SIN(0), SIN(PI()/6), SIN(PI()/4), SIN(PI()/3), SIN(PI()/2))
SELECT ASIN("SIN(0)"), ASIN("SIN(PI()/6)"), ASIN("SIN(PI()/4)"), ASIN("SIN(PI()/3)"), ASIN("SIN(PI()/2)")
FROM Asine

Show:
© 2014 Microsoft