SQL Server/T-SQL Tutorial/Math Functions/Sin — различия между версиями
Admin (обсуждение | вклад) м (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>