SQL Server XLDB_ENGINEERING_VERSION Function
Updated 2023-11-09 19:34:43.937000
Description
Use use the scalar function XLDB_ENGINEERING_VERSION to display version information for the XLeratorDB/engineering module.
Syntax
SELECT [westclintech].[wct].[XLDB_ENGINEERING_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:
| 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_ENGINEERING_VERSION(0);
Here is the result set.
| 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])
Copyright: XLeratorDB (c)2008-2023 WestClinTech LLC, Irvington, NY. WestClinTech.com
Host Application: Microsoft SQL Server 2019 (RTM-CU18-GDR) (KB5021124) - 15.0.4280.7 (X64)
XXX XX XXXX XX:XX:XX
Copyright (C) 2019 Microsoft Corporation
Developer Edition (64-bit) on Windows 10 Pro 10.0