Thursday, March 11, 2010 Register
You are here Products XLeratorDB/math
   


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

Function list from SQL Server Management Studio
SQL Server Math Functions
Privacy StatementTerms Of UseCopyright 2010 WestClinTech LLC

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