Wednesday, March 10, 2010 Register
   


XLeratorDB/engineering's powerful engineering functions bring the power of EXCEL® to T-SQL.

Available for the first time, engineering, base conversion, and complex number functions like BESSELI, ERF, DEC2HEX, BIN2DEC, COMPLEX, IMMULT, IMEXP, IMSUM and many others can be run in any T-SQL statement.

USE ANY OF THESE 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.

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.

 

 

 

 



Try the free 15-day trial today.

 

Function Reference - Engineering Functions
BESSELI calculate the Bessel function of the second kind I±v(z)
BESSELJ calculate the Bessel function of the first kind J±v(z)
BESSELK calculate the Bessel function of the first kind Kv(z)
BESSELY calculate the Bessel function of the first kind Yv(z)
ERF calculate the error function
ERFC calculate the complementary error function
Modulo Modulus as calculated in Excel 
DELTA test whether two values are equal
GESTEP test greater than or equal to a threshold

 

Function Reference - Base Conversions

EBIN2DEC convert a positive binary number to decimal
BIN2DEC convert a binary number to a decimal
BIN2HEX convert a binary number to a hexadecimal
BIN2OCT convert a binary number to an octal
DEC2BIN convert a decimal number to binary
DEC2HEX convert a decimal number to hexadecimal
DEC2OCT convert a decimal number to octal
HEX2DEC convert a hexadecimal number to decimal
HEX2OCT convert a hexadecimal number to octal
HEX2BIN convert a hexadecimal number to binary
OCT2DEC convert an octal number to decimal
OCT2HEX convert an octal number to hexadecimal
OCT2BIN convert an octal number to binary

 

Function Reference - Complex Numbers

COMPLEX convert to a complex number 
IMREAL return the real coefficient of a complex number
IMAGINARY return the imaginary coefficient of a complex number
IMABS calculate the absolute value of a complex number
IMARGUMENT return theta as radians
IMADD return the sum of 2 complex numbers
IMSUB return the difference between 2 complex numbers
IMMULT return the product of 2 complex numbers
IMDIV return the quotient of 2 complex numbers
IMCOS return the cosine of a complex number
IMSIN return the sine of a complex number
IMPOWER return a complex number raised to a power
IMSQRT return the square root of a complex number
IMLN return the natural logarithm of a complex number
IMEXP return the exponential of a complex number
IMLOG10 return the common (base 10) logarithm of a complex number
IMLOG2 return the base-2 logarithm of a complex number
IMCONJUGATE return the complex conjugate of a complex number
IMSUM return the sum of a set of complex numbers
IMSUM_q return the sum of a set of complex numbers
IMPRODUCT return the product of a set of complex numbers
IMPRODUCT_q return the product of a set of complex numbers

 

Function Reference - Version Information

XLDB_ENGINEERING_VERSION Version Information
Function list from SQL Server Management Studio
SQL Server Statistical and Probability functions
 
Privacy StatementTerms Of UseCopyright 2010 WestClinTech LLC

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