SQL Server/T-SQL Tutorial/Math Functions/Sin — различия между версиями

Материал из SQL эксперт
Перейти к: навигация, поиск
м (1 версия)
 
(нет различий)

Текущая версия на 13:24, 26 мая 2010

Sin, COS and Tan

   <source lang="sql">

4> DECLARE @degrees smallint 5> DECLARE @radians float 6> SELECT @degrees=0 7> SELECT @radians=0 8> WHILE (@degrees <= 180) 9> BEGIN 10> SELECT 11> DEGREES=@degrees, 12> RADIANS=STR(@radians, 8, 5), 13> SINE=STR(SIN(@radians), 8, 5), 14> COSINE=STR(COS(@radians), 8, 5), 15> TANGENT=STR(TAN(@radians), 8, 5) 16> SELECT @degrees=@degrees + 10 17> SELECT @radians=RADIANS(CONVERT(float, @degrees)) 18> END 19> GO DEGREES RADIANS SINE COSINE TANGENT


-------- -------- -------- --------
     0  0.00000  0.00000  1.00000  0.00000

(1 rows affected) DEGREES RADIANS SINE COSINE TANGENT


-------- -------- -------- --------
    10  0.17453  0.17365  0.98481  0.17633

(1 rows affected) DEGREES RADIANS SINE COSINE TANGENT


-------- -------- -------- --------
    20  0.34907  0.34202  0.93969  0.36397

(1 rows affected) DEGREES RADIANS SINE COSINE TANGENT


-------- -------- -------- --------
    30  0.52360  0.50000  0.86603  0.57735

(1 rows affected) DEGREES RADIANS SINE COSINE TANGENT


-------- -------- -------- --------
    40  0.69813  0.64279  0.76604  0.83910

(1 rows affected) DEGREES RADIANS SINE COSINE TANGENT


-------- -------- -------- --------
    50  0.87266  0.76604  0.64279  1.19175

(1 rows affected) DEGREES RADIANS SINE COSINE TANGENT


-------- -------- -------- --------
    60  1.04720  0.86603  0.50000  1.73205

(1 rows affected) DEGREES RADIANS SINE COSINE TANGENT


-------- -------- -------- --------
    70  1.22173  0.93969  0.34202  2.74748

(1 rows affected) DEGREES RADIANS SINE COSINE TANGENT


-------- -------- -------- --------
    80  1.39626  0.98481  0.17365  5.67128

(1 rows affected) DEGREES RADIANS SINE COSINE TANGENT


-------- -------- -------- --------
    90  1.57080  1.00000  0.00000 ********

(1 rows affected) DEGREES RADIANS SINE COSINE TANGENT


-------- -------- -------- --------
   100  1.74533  0.98481 -0.17365 -5.67128

(1 rows affected) DEGREES RADIANS SINE COSINE TANGENT


-------- -------- -------- --------
   110  1.91986  0.93969 -0.34202 -2.74748

(1 rows affected) DEGREES RADIANS SINE COSINE TANGENT


-------- -------- -------- --------
   120  2.09440  0.86603 -0.50000 -1.73205

(1 rows affected) DEGREES RADIANS SINE COSINE TANGENT


-------- -------- -------- --------
   130  2.26893  0.76604 -0.64279 -1.19175

(1 rows affected) DEGREES RADIANS SINE COSINE TANGENT


-------- -------- -------- --------
   140  2.44346  0.64279 -0.76604 -0.83910

(1 rows affected) DEGREES RADIANS SINE COSINE TANGENT


-------- -------- -------- --------
   150  2.61799  0.50000 -0.86603 -0.57735

(1 rows affected) DEGREES RADIANS SINE COSINE TANGENT


-------- -------- -------- --------
   160  2.79253  0.34202 -0.93969 -0.36397

(1 rows affected) DEGREES RADIANS SINE COSINE TANGENT


-------- -------- -------- --------
   170  2.96706  0.17365 -0.98481 -0.17633

(1 rows affected) DEGREES RADIANS SINE COSINE TANGENT


-------- -------- -------- --------
   180  3.14159  0.00000 -1.00000 -0.00000

(1 rows affected) 1></source>


SIN returns a float value that is the sine of the angle passed in as a parameter.

   <source lang="sql">

Note that the angle passed in must be in radians. 5> SELECT SIN(1.2) 6> GO


    0.93203908596722629

(1 rows affected)</source>