XLDB_FINANCIAL_VERSION

Updated 2023-10-12 15:33:20.683000

Syntax

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

Description

Use the scalar function XLDB_FINANCIAL_VERSION to display version information for the XLeratorDB/financial module.

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(4000)

Remarks

InfoType values:

{"columns":[{"field":"column 1","width":193},{"field":"column 2","width":445}],"rows":[{"column 1":"0","column 2":"Simple version information is returned in the format (x.xx.xxxx.xx) – Major version, minor version, build and revision."},{"column 1":"1,V,Verbose","column 2":"Version and Registration information is returned, including version, build, licensed user name, license key, server name, expiration date, etc."}]}

Examples

select wct.XLDB_FINANCIAL_VERSION(0);

Here is the result set.

{"columns":[{"field":"column 1"}],"rows":[{"column 1":"1.02.1215.4"}]}

select wct.XLDB_FINANCIAL_VERSION(1);

Here is the result set.

{"columns":[{"field":"column 1"}],"rows":[{"column 1":"XLeratorDB-financial ver. 1.02"},{"column 1":"CustomerID: trial_XLDB-fin-Trial_20081215_v01.02"},{"column 1":"License Key: 111111"},{"column 1":"Expiration Date: 12/30/2008"},{"column 1":"Build: 1215.4"},{"column 1":"XLeratorDB (c)2008 WestClinTech LLC, Irvington, NY. www.westclintech.com"}]}