T-SQL Mathematic Functions – Microsoft SQL

It perform a calculation, usually based on input values and return a numeric value.
Below is All built-in Sql Mathematic Function :
ABS, DEGREES, RAND, ACOS, EXP, ROUND, ASIN, FLOOR, SIGN, ATAN, LOG, SIN, ATN2, LOG10, SQUARE, CEILING, PI, SQRT, COS, POWER, TAN, COT, RADIANS

Example SQL Mathematic FunctionsABS
– Returns the absolute and positive value.
Syntax ABS ( numeric )
SELECT ABS(-1.0) — Value = 1.0
SELECT ABS(0.0) — Value =
0.0
SELECT ABS(1.0) — Value =
1.0

Example SQL Mathematic FunctionsDEGREES
– returns angle in degrees from radian value.
Syntax
DEGREES( numeric)
SELECT DEGREES(1) — Value = 57 degrees
SELECT DEGREES(2) — Value = 114 degrees

Example SQL Mathematic FunctionsFLOOR
– Returns the largest integer less than or equal to the given numeric expression.
SyntaxFLOOR( numeric)

SELECT FLOOR(32.15) — Value = 32
SELECT FLOOR(-32.15) — Value = -33
SELECT FLOOR($32.15) — Value = 32.0000

Example SQL Mathematic FunctionsCEILING
– Returns the smallest integer greater than, or equal to the input value
SyntaxCEILING( numeric)
SELECT CEILING(32.15) — Value = 33
SELECT CEILING(-32.15) — Value = -32
SELECT CEILING($32.15) — Value =
33.0000

Example SQL Mathematic FunctionsROUND
– Return rounded value.
Syntax ROUND( numeric, length)
SELECT ROUND(32.15 ,1) — Value = 32.20
SELECT ROUND(32.14 ,1) — Value = 32.10
SELECT ROUND(32.14998 ,4) — Value = 32.15000
SELECT ROUND(32.14992 ,4) — Value = 32.14990
SELECT ROUND(32.92 ,0) — Value = 33.00

Example SQL Mathematic Functions – POWER
– Returns the value of input to the specified power.
Syntax POWER( numeric, power(integer))

SELECT POWER(6,2) — Value = 36 (6*6)
SELECT POWER(9,3) — Value = 729 (9*9*9)

About onlinejt

Blogger

, ,

No comments yet.

Leave a Reply

*