SQL Server XLDB_MATH_VERSION Function

Updated 2023-10-20 16:00:56.383000

Description

Use the scalar function XLDB_MATH_VERSION to display version information for the XLeratorDB/math module.

Syntax

SELECT [westclintech].[wct].[XLDB_MATH_VERSION] (
  <@InfoType, nvarchar(4000),>)

Arguments

@InfoType

is a specifier that determines the verbosity of the returned version information. @InfoType must be of a data type that is implicitly convertible to varchar.

Return Type

nvarchar(max)

Remarks

InfoType values:

column 1	column 2
0	Simple version information is returned in the format (x.xx.xxxx.xx) – Major version, minor version, build and revision.
1,V,Verbose	Version and Registration information is returned, including version, build, licensed user name, license key, server name, expiration date, etc.

Examples

select wct.XLDB_MATH_VERSION(0);

Here is the result set.

column 1
1.03.118.144

select wct.XLDB_MATH_VERSION(1);