SQL Server XLDB_OPTIONS_VERSION Function

Updated 2023-11-17 15:45:01.833000

Description

Use the scalar function XLDB_OPTIONS_VERSION to display version information for the XLeratorDB/financial-options module.

Syntax

SELECT [westclintech].[wct].[XLDB_OPTIONS_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(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_OPTIONS_VERSION(0);

Here is the result set.

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

select wct.XLDB_OPTIONS_VERSION(1);

Here is the result set.

Product: XLeratorDB-options Version: 1.03 Build: 0311.723 License Ver: X CustomerID: XLDB-options_Full_v1.03 OrderID: -1 / -1 Retail Edition: Standard License Key: XXXXXX License Plan: Standard Order Date: Saturday, XXXXX XX, XXXX License SQL Server Cluster Type: Non-Clustered Current Server: XXXXXXXXXXXXXXXXXX Current Server is Clustered: NO Expiration Date: XX/XX/XXXX OS: Microsoft Windows NT 6.2.9200.0; (Win32NT) Processors: X .NET: 4.0.30319.42000 Culture: en-US : English (United States) (1033[ovr]) Copyright: XLeratorDB (c)2008-2023 WestClinTech LLC, Irvington, NY. WestClinTech.com Host Application: Microsoft SQL Server 2022 (RTM-GDR) (KB5029379) - 16.0.1105.1 (X64)     Aug 24 2023 02:40:55     Copyright (C) 2022 Microsoft Corporation     Developer Edition (64-bit) on Windows 10 Pro 10.0 (Build 19045: )