SQLEngineering extends and enhances your T-SQL programming environment by adding a suite of 116 advanced mathematical functions for scientific and engineering use, including:

• Cylindrical and Spherical Bessel / Neumann functions.
• Laguerre, Legendre, Hermite polynomials and Spherical Harmonics.
• Elliptical integrals.
• Error functions.
• Exponential integrals.
• Complex numbers implemented as a new SQL type including 53 different arithmetic, trigonometric and hyperbolic functions.
• Number base conversions between decimal, hexadecimal, binary, octal and base64.
• Unit conversions for 196 different units of measure (including distance, velocity, acceleration, area, volume, mass, density, pressure, flow, energy, power, time, temperature, flux, angle etc).

Beyond Excel

A few of the functions available in SQLEngineering (e.g. some of the base and unit conversions) are numerically faithful equivalents of similar functions found in Microsoft Excel, but offer a much broader range of functionality. These - and the many additional functions that have no analogue in Excel - use the innate power and ability of SQL Server to rapidly crunch through huge volumes of data - giving you an analytical capability that completely blows away anything you could do with spreadsheets.

Native Look and Feel

All TotallySQL Transact-SQL extensions are implemented using familiar programming objects within SQL (scalar and table-valued functions, aggregate functions, user-defined types, stored procedures) , keeping the syntax clean and making them as fast and easy to use as the built-in native functions such as SUM, AVG etc.

Outstanding Performance and Numerical Accuracy

The algorithms behind the SQLEngineering functions use industry-proven, best-in-class techniques devised by some of the world's leading numerical computing experts to maximise performance and accuracy even for fairly extreme input values. Careful heuristics and edge-case checks through the code ensure that problems caused by the limitations of floating-point arithmetic on digital computers (such as cancellation errors) are kept to an absolute mininum, and a broad range of special-purpose, high-performance numerical computing approaches are used in place of the slow, expensive computations that would result from 'naive' implementations of the underlying mathematics.