|
XLeratorDB/math's powerful math functions bring the power of EXCEL® to T-SQL.
Available for the first time, functions like FACT, PRODUCT, MROUND, MULTINOMIAL, RANDBETWEEN, COMBIN, and ROUNDUP can be run in any T-SQL statement.
USE ANY OF THESE 33 functions in SELECT, UPDATE, DELETE, or INSERT statements. Use them in views, common table expressions, stored procedures, or user-defined functions. Use these functions wherever you would use a built-in SQL Server® function. Go to documentation to see a complete list of functions.
XLeratorDB functions utilize SQLCLR technology and work like any other user-defined function. Once you start using these functions in the T-SQL environment, you will immediately realize how much more powerful they become outside of EXCEL. The combination of the SQL Server database platform and these powerful functions, enables you to perform calculations on millions of rows of data or simply a few rows of data. simply by changing a WHERE clause.
YOU WILL NEVER HAVE TO WORRY about exporting data or copying formulae again. You can always be sure that everything that meets your criteria is included in your calculations. You no longer need to use LOOKUP functions; you can simply join to the table that you need to get the data that you want.
YOU WILL NEVER have to worry about importing the results of a spreadsheet calculation back into the database. Always feel confident in the accuracy of the calculation.
XLeratorDB/math installs in minutes and is available for use immediately. Anyone comfortable with EXCEL will intuitively know how these functions work.
Try the 15-day trial today.
List of SQL Server Math Functions:
ACOSH
|
Inverse Hyperbolic Cosine
|
ASINH
|
Inverse Hyperbolic Sine
|
ATANH
|
Inverse Hyperbolic Tangent
|
CEILING
|
Ceiling to a multiple
|
COMBIN
|
Combinatorial
|
COSH
|
Hyperbolic Cosine
|
CSC
|
Cosecant
|
EGCD
|
Euclidean GCD
|
ELCM
|
Euclidean LCM
|
EVEN
|
Nearest Even
|
FACT
|
Factorial
|
FACTDOUBLE
|
Double Factorial
|
FLOOR
|
Floor to a multiple
|
GCD
|
Greatest Common Divisor
|
INT
|
Integer
|
INTERP
|
Linear interpolation
|
INTERP_q
|
Linear interpolation
|
LCM
|
Least Common Multiple
|
MROUND
|
Round to a multiple
|
MULTINOMIAL
|
Sum of squares
|
ODD
|
Nearest Odd
|
PRODUCT
|
Product of Values (similar to SUM)
|
QUOTIENT
|
Integer portion of a division
|
RANDBETWEEN
|
Random integer between two values
|
ROMAN
|
Convert to Roman Numerals
|
ROUNDDOWN
|
Round toward zero
|
ROUNDUP
|
Round away from zero
|
SEC
|
Secant
|
SERIESSUM
|
Sum of a Power Series
|
SINH
|
Hyberbolic Sine
|
SPLINE
|
Cubic spline interpolation
|
SPLINE_q
|
Cubic spline interpolation
|
SUMSQ
|
Sum of the Squares
|
TANH
|
Hyperbolic Tangent
|
TRUNC
|
Truncate to Integer
|
|