Tuesday, September 07, 2010 Register
XLeratorDB/math Online Documentation
Home

XLeratorDB/math

Use XLeratorDB/math for a wide variety of mathematical calculations. The feature-rich XLeratorDB math function library lets you include calculations in any T-SQL statement including SELECT, INSERT, UPDATE, DELETE, CREATE VIEW as well as in CTEs, stored procedures, user-defined functions, and computed columns.

XLeratorDB/math requires Microsoft  SQL Server®  2005 or later (which must be purchased separately) . XleratorDB/math installs in minutes and can be used immediately after installation. Anyone familiar with the functions in Microsoft Excel® will immediately feel comfortable with XLeratorDB/math.

Function Reference - 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
MULTINOMIAL_q Sum of squares
ODD Nearest Odd
PRODUCT Product of Values (similar to SUM)
QUOTIENT Integer portion of a division
RAND Returns a random float >=0 and <1
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
SERIESSUM_q 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

 


Function Reference - Matrix Functions

MDETERM Matrix Determinant
MDETERM_q Matrix Determinant
MDETERMN Matrix Determinant (normalized input)
MDETERMN_q Matrix Determinant (normalized input)
MMULT Matrix Multiplication
MMULT_q Matrix Multiplication
MMULTN Matrix Multiplication (normalized input)
MMULTN_q Matrix Multiplication (normalized input)
MINVERSE Matrix Inverse
MINVERSE_q Matrix Inverse
MINVERSEN Matrix Inverse (normalized input)
MINVERSEN_q Matrix Inverse (normalized input)


Function Reference - Series Functions

SeriesInt Generate a range of Integer values (Table Valued function)
SeriesFloat Generate a range of float values (Table Valued function)
SeriesDate Generate a range of date values (Table Valued function)

 

Function Reference - Version Information

XLDB_MATH_VERSION Version Information

 


 |  View Topic History  |
Print  
Privacy StatementTerms Of UseCopyright 2010 WestClinTech LLC

BorderBoxedGrayBoxedGreenBlue Small width layoutMedium width layoutMaximum width layoutMaximum textMedium textSmall textBack Top!