SQL Server XLDB_ENGINEERING_VERSION Function

Updated 2023-11-09 19:34:43.937000

Syntax

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

Description

Use use the scalar function XLDB_ENGINEERING_VERSION to display version information for the XLeratorDB/engineering 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_ENGINEERING_VERSION(0);

Here is the result set.

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

select wct.XLDB_ENGINEERING_VERSION(1);

Here is the result set.

Product: XLeratorDB-engineering

Version: 1.01

Build: 0311.723

License Ver: 6

CustomerID: XLDB-engineering_Full_v01.01

OrderID: -1 / -1

Retail Edition: Standard

License Key: XXXXXX

License Plan: Standard

Order Date: XXXXXXXX, XXXXX XX, XXXX

License SQL Server Cluster Type: Non-Clustered

Current Server: XXXXXXXXX

(aliased Server name: XXXXXXXXX\XXXXXXXXXX)

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])

Host Application: Microsoft SQL Server 2019 (RTM-CU18-GDR) (KB5021124) - 15.0.4280.7 (X64)

XXX XX XXXX XX:XX:XX

Developer Edition (64-bit) on Windows 10 Pro 10.0 (Build 19045: )