wct.XLDB_MATH_VERSION
Updated: 21 January 2010
Use wct.XLDB_MATH_VERSION to display version information for the XLeratorDB/math module.
Syntax
SELECT [wctStatistics].[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 Types
nvarchar
Remarks
· InfoType values:
|
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.
|
Example
select wct.XLDB_MATH_VERSION(0)
Here is the result set
----------------------
1.03.118.144
(1 row(s) affected)
select wct.XLDB_MATH_VERSION(1)
Here is the result set
----------------------
XLeratorDB-math ver. 1.03
CustomerID: trial_XLDB-math-Trial_20100115_v01.030
Retail Edition: Trial
License Key: 111111
Current Server: PC03
Expiration Date: 01/30/2010
Build: 0118.144
XLeratorDB (c)2008-2009 WestClinTech LLC, Irvington, NY. www.westclintech.com
RDBMS Server Version:
Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86)
Nov 24 2008 13:01:59
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 3)
(1 row(s) affected)