|
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
 |