Login     Register

        Contact Us     Search

XLeratorDB/financial-options Documentation

XLeratroDB / options version information


XLDB_OPTIONS_VERSION
 
Updated: 04 September 2012

Use wct.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 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_OPTIONS_VERSION(0)
Here is the result set
----------------------
1.00.0904.314
 
(1 row(s) affected)



select wct.XLDB_OPTIONS_VERSION(1)
Here is the result set
----------------------

XLeratorDB-options ver. 1.00
License Ver. 4
CustomerID: xxxx@xxxxxx.com
OrderID: -1 / -1
Retail Edition: Standard
License Key: 653754-jvbL6c
License Plan: Standard
Order Date: Tuesday, September 11, 2012
License SQL Server Cluster Type: Non-Clustered
Licensed Servers: XXXX
Current Server: XXXX
(aliased Server name: XXXX\SQL2005DEVX86)
Current Server is Clustered: NO
Expiration Date: 12/31/2099
Build: 0904.314
XLeratorDB (c)2008-2012 WestClinTech LLC, Irvington, NY.  WestClinTech.com

Host Application Version:
    Microsoft SQL Server 2005 - 9.00.5057.00 (Intel X86)
    Mar 25 2011 13:50:04
    Copyright (c) 1988-2005 Microsoft Corporation
    Developer Edition on Windows NT 6.1 (Build 7601: Service Pack 1)

 

 



Copyright 2008-2013 WestClinTech LLC         Privacy Policy        Terms of Service