 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 Calculate the Bessel function of the second kind I±v(z). Calculate the Bessel function of the first kind J±v(z). Calculate the Bessel function of the first kind Kv(z). Calculate the Bessel function of the first kind Yv(z). Calculate the error function. Calculate the complementary error function. Return the amount by which a number exceeds the largest integer multiple of the divisor that is not greater than that number. Test whether two values are equal. Test whether a number is greater than or equal to a threshold value. BASE CONVERSIONS Convert an unsigned positive binary number to decimal. Convert a binary number to a decimal. Convert a binary number to a hexadecimal. Convert a binary number to an octal. Convert a decimal number to binary. Convert a decimal number to hexadecimal. Convert a decimal number to octal. Convert a hexadecimal number to decimal. Convert a hexadecimal number to octal. Convert a hexadecimal number to binary. Convert an octal number to decimal. Convert an octal number to hexadecimal. Convert an octal number to binary. COMPLEX NUMBERS Convert real and imaginary coefficients into a complex number of the form x + yi or x + yj. Return the real coefficient of a complex number in the x + yi or x + yj format. Return the imaginary coefficient of a complex number in the x + yi or x + yj format. Calculate the absolute value of a complex number in the x + yi or x + yj format. Return theta, an angle expressed in radians. Return the sum of 2 complex numbers in x + yi or x + yj text format. Return the difference between 2 complex numbers in x + yi or x + yj text format. Return the product of 2 complex numbers in x + yi or x + yj text format. Return the quotient of 2 complex numbers in x + yi or x + yj text format. Return the cosine of a complex number in x + yi or x + yj text format. Return the sine of a complex number in x + yi or x + yj text format. Return a complex number in x + yi or x + yj text format raised to a power. Return the square root of a complex number in x + yi or x + yj text format. Return the natural logarithm of a complex number in x + yi or x + yj text format. Return the exponential of a complex number in x + yi or x + yj text format. Return the common (base 10) logarithm of a complex number in x + yi or x + yj text format. Return the base-2 logarithm of a complex number in x + yi or x + yj text format. Return the complex conjugate of a complex number in x + yi or x + yj format. Return the sum of a dataset of complex numbers in x + yi or x + yj text format. † Return the sum of a dataset of complex numbers in x + yi or x + yj text format. † Return the product of a dataset containing complex numbers in x + yi or x + yj text format. † Return the product of a dataset containing complex numbers in x + yi or x + yj text format. † FUNCTION REFERENCE - UNIT CONVERSION FUNCTIONS AREA Convert to and from acres, hectares, square feet, square inches, square meters, square miles, or square yards. Convert area to acres. Convert area to hectares. Convert area to square inches. Convert area to square feet. Convert area to square yards. Convert area to square miles. Convert area to square meters. LENGTH Convert to and from fathoms, feet, furlongs, inches, meters, miles, nautical miles, pica, points, or yards. Convert length to inches. Convert length to feet. Convert length to yards. Convert length to meters. Convert length to miles. Convert length to nautical miles. Convert length to fathoms. Convert length to furlongs. Convert length to pica. Convert length to points. SPEED 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. Convert speed to inches per second. Convert speed to feet per second. Convert speed to feet per minute. Convert speed to feet per hour. Convert speed to miles per hour. Convert speed to meters per second. Convert speed to meters per minute. Convert speed to meters per hour. Convert speed to kilometers per hour. Convert speed to miles per second. Convert speed to miles per minute. Convert speed to miles per hour. Convert speed to knots. TEMPERATURE Convert to and from Celsius, Fahrenheit, Kelvin, or Rankine. Convert from Fahrenheit, Kelvin, or Rankine to Celsius. Convert from Celsius, Kelvin, or Rankine to Fahrenheit. Convert from Celsius, Fahrenheit, or Rankine to Kelvin. Convert from Celsius, Fahrenheit, or Kelvin to Rankine. 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. Convert from volume to cubic inches. Convert from volume to cubic feet. Convert from volume to cubic yards. Convert from volume to cubic meters. Convert from volume to cubic miles. Convert from volume to fluid drams. Convert from volume to fluid ounces. Convert from volume to teaspoons. Convert from volume to tablespoons. Convert from volume to cups. Convert from volume to pints. Convert from volume to quarts. Convert from volume to gallons. Convert from volume to liters. Convert from volume to imperial ounces. Convert from volume to imperial pints. Convert from volume to imperial quarts. Convert from volume to imperial gallons. Convert from volume to imperial gills. Convert from volume to barrels. Convert from volume to bbls. Convert from volume to bushels. Convert from volume to gills. Convert from volume to pecks. Convert from volume to dry pints. Convert from volume to dry quarts. Convert from volume to steres. WEIGHT Convert to and from drams, grains, grams, hundredweights, ounces, pennyweights, pounds, stones, tonnes, tons, troy pounds, or troy ounces. Convert weigth to ounces. Convert weigth to grains. Convert weigth to drams. Convert weigth to pounds. Convert weigth to stones. Convert weigth to hundredweights. Convert weigth to tons. Convert weigth to pennyweights. Convert weigth to troy ounces. Convert weigth to troy pounds. Convert weigth to troy pounds. Convert weigth to tonnes. OTHER Get version information for the XLeratorDB / engineering library.

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

Support  Copyright 2008-2022 Westclintech LLC         Privacy Policy        Terms of Service