MSSQL Math Functions 41 codes

1 % mod operator

2 ABS

3 ACOS

4 ACOS is the inverse of COS

5 ASIN

6 Case when with Mod and ABS()

7 CEILING

8 CEILING(-98 1)

9 CEILING(-98 9)

10 COS

11 COT

12 DEGREES

13 DEGREES(ACOS(0 5))

14 EXP

15 FLOOR

16 Floor a value

17 FLOOR(23 7)

18 LOG10

19 PI

20 POWER

21 RADIANS

22 RAND

23 ROUND

24 Round the updated data

25 ROUND(100 345678,5,1)

26 ROUND(107 345678,-1,0)

27 Select ISNUMERIC(-1 25)

28 Select ISNUMERIC(2001-09-30)

29 Select ISNUMERIC(SQL Server)

30 Select ROUND(12 4999,0)

31 Select ROUND(12 4999,1)

32 Select ROUND(12 4999,-1) (minus)

33 Select ROUND(12 5,0)

34 Select ROUND(12 5,0,1)

35 SIGN

36 SIN

37 SQRT

38 SQUARE

39 TAN

40 Use Log10

41 Use select to do the calculation