Wednesday, March 10, 2010 Register
Home
No Comments Yet

XLeratorDB/engineering

Use XLeratorDB/engineering for a wide variety of engineering calculations. The feature-rich XLeratorDB engineering 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/engineering requires Microsoft  SQL Server®  2005 or later (which must be purchased separately). XLeratorDB/engineering installs in minutes and can be used immediately after installation. Anyone familiar with the functions in Microsoft Excel® will immediately feel comfortable with XLeratorDB/engineering.

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


  Comments

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

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