Login     Register

        Contact Us     Search

XLeratorDB/engineering Online Documentation

SQL Server Engineering function


XLeratorDB / engineering

Use XLeratorDB / engineering for a wide variety of engineering calculations and unit conversion. The feature-rich XLeratorDB 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.

The XLeratorDB / engineering functions work with SQL Server 2005 and later; the package installs in minutes and can be used immediately after installation. Anyone familiar with the engineering functions in Microsoft Excel® will immediately feel comfortable with XLeratorDB / engineering

FUNCTION REFERENCE - ENGINEERING FUNCTIONS
ENGINEERING
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
 
Return the amount by which a number exceeds the largest integer multiple of the divisor that is not greater than that number.
 
DELTA
 
Test whether two values are equal.
 
GESTEP
 
Test whether a number is greater than or equal to a threshold value.
 
 
BASE CONVERSIONS
EBIN2DEC
 
Convert an unsigned 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.
 
 
COMPLEX NUMBERS
COMPLEX
 
Convert real and imaginary coefficients into a complex number of the form x + yi or x + yj.
 
IMREAL
 
Return the real coefficient of a complex number in the x + yi or x + yj format.
 
IMAGINARY
 
Return the imaginary coefficient of a complex number in the x + yi or x + yj format.
 
IMABS
 
Calculate the absolute value of a complex number in the x + yi or x + yj format.
 
IMARGUMENT
 
Return theta, an angle expressed in radians.
 
IMADD
 
Return the sum of 2 complex numbers in x + yi or x + yj text format.
 
IMSUB
 
Return the difference between 2 complex numbers in x + yi or x + yj text format.
 
IMMULT
 
Return the product of 2 complex numbers in x + yi or x + yj text format.
 
IMDIV
 
Return the quotient of 2 complex numbers in x + yi or x + yj text format.
 
IMCOS
 
Return the cosine of a complex number in x + yi or x + yj text format.
 
IMSIN
 
Return the sine of a complex number in x + yi or x + yj text format.
 
IMPOWER
 
Return a complex number in x + yi or x + yj text format raised to a power.
 
IMSQRT
 
Return the square root of a complex number in x + yi or x + yj text format.
 
IMLN
 
Return the natural logarithm of a complex number in x + yi or x + yj text format.
 
IMEXP
 
Return the exponential of a complex number in x + yi or x + yj text format.
 
IMLOG10
 
Return the common (base 10) logarithm of a complex number in x + yi or x + yj text format.
 
IMLOG2
 
Return the base-2 logarithm of a complex number in x + yi or x + yj text format.
 
IMCONJUGATE
 
Return the complex conjugate of a complex number in x + yi or x + yj format.
 
IMSUM
 
Return the sum of a dataset of complex numbers in x + yi or x + yj text format. 
 
IMSUM_q
 
Return the sum of a dataset of complex numbers in x + yi or x + yj text format. 
 
IMPRODUCT
 
Return the product of a dataset containing complex numbers in x + yi or x + yj text format. 
 
IMPRODUCT_q
 
Return the product of a dataset containing complex numbers in x + yi or x + yj text format. 
 
 
 
FUNCTION REFERENCE - UNIT CONVERSION FUNCTIONS 
AREA
CONVERTAREA
 
Convert to and from acres, hectares, square feet, square inches, square meters, square miles, or square yards.
 
ACRES
 
Convert area to acres.
 
HECTARES
 
Convert area to hectares.
 
SQINCHES
 
Convert area to square inches.
 
SQFEET
 
Convert area to square feet.
 
SQYARDS
 
Convert area to square yards.
 
SQMILES
 
Convert area to square miles.
 
SQMETERS
 
Convert area to square meters.
 
 
LENGTH
CONVERTLENGTH
 
Convert to and from fathoms, feet, furlongs, inches, meters, miles, nautical miles, pica, points, or yards.
 
INCHES
 
Convert length to inches.
 
FEET
 
Convert length to feet.
 
YARDS
 
Convert length to yards.
 
METERS
 
Convert length to meters.
 
MILES
 
Convert length to miles.
 
NMILES
 
Convert length to nautical miles.
 
FATHOMS
 
Convert length to fathoms.
 
FURLONGS
 
Convert length to furlongs.
 
PICA
 
Convert length to pica.
 
POINTS
 
Convert length to points.
 
 
SPEED
CONVERTSPEED
 
Convert to and from feet per hour, feet per minute, feet per second, inches per second, kilometers per hour, knots, miles per hour, miles per minute, miles per second, meters per second, meters per minute, or meters per hour.
 
INSEC
 
Convert speed to inches per second.
 
FTSEC
 
Convert speed to feet per second.
 
FTMIN
 
Convert speed to feet per minute.
 
FTHR
 
Convert speed to feet per hour.
 
MIHR
 
Convert speed to miles per hour.
 
MSEC
 
Convert speed to meters per second.
 
MMIN
 
Convert speed to meters per minute.
 
MHR
 
Convert speed to meters per hour.
 
KMHR
 
Convert speed to kilometers per hour.
 
MISEC
 
Convert speed to miles per second.
 
MIMIN
 
Convert speed to miles per minute.
 
MIHR
 
Convert speed to miles per hour.
 
KNOTS
 
Convert speed to knots.
 
 
TEMPERATURE
CONVERTTEMP
 
Convert to and from Celsius, Fahrenheit, Kelvin, or Rankine.
 
CELSIUS
 
Convert from Fahrenheit, Kelvin, or Rankine to Celsius.
 
FAHRENHEIT
 
Convert from Celsius, Kelvin, or Rankine to Fahrenheit.
 
KELVIN
 
Convert from Celsius, Fahrenheit, or Rankine to Kelvin.
 
RANKINE
 
Convert from Celsius, Fahrenheit, or Kelvin to Rankine.
 
 
VOLUME
CONVERT VOLUME
 
Convert to and from barrels (US beer barrels), bbl (oil barrel), bushels, cubic feet, cubic inches, cubic meters, cubic miles, cubic yards, cups, dry pints, dry quarts, fluid drams, fluid ounces, gallons, gills, imperial gallons, imperial gills, imperial pints, imperial quarts, liters, pecks, pints, quarts, steres, tablespoons, or teaspoons.
 
CUINCHES
 
Convert from volume to cubic inches.
 
CUFEET
 
Convert from volume to cubic feet.
 
CUYARDS
 
Convert from volume to cubic yards.
 
CUMETERS
 
Convert from volume to cubic meters.
 
CUMILES
 
Convert from volume to cubic miles.
 
FLDRAMS
 
Convert from volume to fluid drams.
 
FLOUNCES
 
Convert from volume to fluid ounces.
 
TEASPOONS
 
Convert from volume to teaspoons.
 
TABLESPOONS
 
Convert from volume to tablespoons.
 
CUPS
 
Convert from volume to cups.
 
PINTS
 
Convert from volume to pints.
 
QUARTS
 
Convert from volume to quarts.
 
GALLONS
 
Convert from volume to gallons.
 
LITERS
 
Convert from volume to liters.
 
IMPOUNCES
 
Convert from volume to imperial ounces.
 
IMPPINTS
 
Convert from volume to imperial pints.
 
IMPQUARTS
 
Convert from volume to imperial quarts.
 
IMPGALLONS
 
Convert from volume to imperial gallons.
 
IMPGILLS
 
Convert from volume to imperial gills.
 
BARRELS
 
Convert from volume to barrels.
 
BBLS
 
Convert from volume to bbls.
 
BUSHELS
 
Convert from volume to bushels.
 
GILLS
 
Convert from volume to gills.
 
PECKS
 
Convert from volume to pecks.
 
DRYPINTS
 
Convert from volume to dry pints.
 
DRYQUARTS
 
Convert from volume to dry quarts.
 
STERES
 
Convert from volume to steres.
 
 
WEIGHT
CONVERTWEIGHT
 
Convert to and from drams, grains, grams, hundredweights, ounces, pennyweights, pounds, stones, tonnes, tons, troy pounds, or troy ounces.
 
OUNCES
 
Convert weigth to ounces.
 
GRAINS
 
Convert weigth to grains.
 
DRAMS
 
Convert weigth to drams.
 
POUNDS
 
Convert weigth to pounds.
 
STONES
 
Convert weigth to stones.
 
CWT
 
Convert weigth to hundredweights.
 
TON
 
Convert weigth to tons.
 
DWT
 
Convert weigth to pennyweights.
 
TROY
 
Convert weigth to troy ounces.
 
TPOUNDS
 
Convert weigth to troy pounds.
 
GRAMS
 
Convert weigth to troy pounds.
 
TONNES
 
Convert weigth to tonnes.
 
 
OTHER
XLDB_ENGINEERING_VERSION
 
Get version information for the XLeratorDB / engineering library.
 

This function cannot reference data from SQL Server 2014 memory-optimized tables

 



Copyright 2008-2017 Westclintech LLC         Privacy Policy        Terms of Service