The large majority of math functions are specific to applications using trigonometry, calculus, and geometry. This are very important and it is very difficult to have all of them together at place.
Math Functions
Absolute value ABS
Arc cosine ACOS
Arc sine ASIN
Arc tangent of n ATAN
Arc tangent of n and m ATN2
Smallest integer >= value CEILING
Cosine COS
Hyperbolic cosine COT
Exponential value EXP
Round down to nearest integer FLOOR
Natural logarithm LOG
Logarithm, base 10 LOG10
Modulus (remainder) USE MODULO (%) OPERATOR
Power POWER
Random number RAND
Round ROUND
Sign of number SIGN
Sine SIN
Square root SQRT
Tangent TAN
Convert number if NULL ISNULL
Standard deviation STDEV
Variance VAR
Reference : Pinal Dave (http://blog.SQLAuthority.com) , BOL Math Functions
pinaldave
is there a way to do a division and modulo in the same statement? I’d like the result of the division to go into one variable and the remainder into another.
how to use MOD function in sql server 2005 .
I want record like 101 201 301 out of 100000 rows