MSSQL Tutorial Math Functions 53 codes

1 ABS function returns the absolute value of any number passed to it

2 ACOS Returns as a float data type, the angle in radians that corresponds to the entered cosine, which must have values betw

3 ASIN Returns as a float data type, the angle in radians that corresponds to the entered sine, which must have values betwee

4 ATAN Returns as a float data type, the angle in radians that corresponds to the entered tangent

5 CASE with FLOOR function

6 CEILING function returns the value representing the smallest integer that is greater-than or equal to the input_number

7 Computing the modulus with FLOOR

8 COS Returns a float value that is the cosine of the angle passed in as a parameter

9 COT returns a float value that is the cotangent of the angle passed in as a parameter

10 DEGREES converts a float value, which represents an angle in radians, into the value of this angle in degrees

11 EXP Returns a float, which is the exponential of the float value passed in as a parameter

12 FLOOR returns the value that represents the largest integer that is less-than or equal to the input_number

13 LOG Takes one positive valued parameter, and returns the natural logarithm of this parameter as a float value

14 LOG10 returns the base 10 logarithm of this parameter as a float value

15 MAX(CEILING(price))

16 MIN(FLOOR(price))

17 PI Returns the value of the mathematical constant PI to 16 decimal places

18 POWER returns a number (input_x) raised to the power of a number (input_y)

19 RADIANS Converts a value in degrees to a value in radians

20 RAND Generates a random number between 0 and 1, which is returned as a float

21 RAND Returns random number from 0 to 1

22 Returning the decimal portion using FLOOR

23 ROUND(salary 1 1, 2)

24 Rounding present value to two decimal places

25 Rounds a value to the number of decimal places specified in the second parameter

26 Select ABS(-1 25)

27 Select CEILING (1 25)

28 Select CEILING(-1 25) (Minus)

29 Select FLOOR(1 25)

30 Select FLOOR(-1 25) (minus)

31 Select ISNUMERIC(-1 25)

32 SELECT ISNUMERIC(123)

33 SELECT ISNUMERIC(123ABC)

34 Select ISNUMERIC(2001-09-30)

35 Select ISNUMERIC(SQL Server)

36 SELECT POWER(10,2) Result

37 Select RAND()

38 SELECT RAND(22) Result

39 Select ROUND(12 4999,0)

40 Select ROUND(12 4999,1)

41 Select ROUND(12 4999,-1) (Minus)

42 Select ROUND(12 5,0)

43 Select ROUND(12 5,0,1)

44 SELECT ROUND(3 22245, 3) RoundedNumber

45 SELECT SQRT(100) Result

46 Select SQRT(125 43)

47 Select SQUARE(5 2786)

48 SIGN returns a -1 if the number is negative, +1 if the number is positive, or 0 if the number is 0

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

50 Sin, COS and Tan

51 SQRT function returns the square root of a value 0 or greater

52 SQUARE Returns the square of the given number

53 TAN return a float value that is the tangent of the angle passed in as a parameter