h1

Toate functiile matematice mssql

March 2, 2010

1) Functia ABS

– calculeaza modulul unui numar

2) Functii trigonometrice

a) Functia ACOS: (exemple)

b) Functia ASIN si ATAN

c) ATN2

d) COS si COT

e) TAN

3) Functiile DEGREES si RADIANS

Alte exemple cu RADIANS (pt.conversie din grade in radiani):

4) Functiile RAND, ROUND si SIGN

RAND – intoarce un numar aleator intre 0 si 1

ROUND – rotunjeste un numar

AS – este un cuvant rezervat din mssql si da numele unei coloane (se mai numeste si alias-ul coloanei= numele coloanei)

SIGN – intoarce -1 daca e nr.negativ, 0 daca =0 si 1 daca e nr.pozitiv (functia semn)

5) Functiile SQUARE, POWER si SQRT

6) Functiile LOG si EXP

7) Functiile FLOOR si CEILING

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: