ASA SQL Reference
System Procedures and Functions
System extended stored procedures
Other system extended stored procedures
Retrieves version and name information about the database server.
xp_msver ( string )
The string must be one of the following, enclosed in string delimiters.
| Argument | Description |
|---|---|
| ProductName | The name of the product (Sybase Adaptive Server Anywhere) |
| ProductVersion |
The version number, followed by the build number. The format is as follows:
9.0.0 (1200) |
| CompanyName |
Returns the following string:
Sybase Inc. |
| FileDescription | Returns the name of the product, followed by the name of the operating system. |
| LegalCopyright | Returns a copyright string for the software |
| LegalTrademarks | Returns trademark information for the software |
None
xp_msver returns product, company, version, and other information.
The following statement requests the version and operating system description:
SELECT xp_msver( 'ProductVersion') Version,
xp_msver('FileDescription') DescriptionSample output is as follows:
| Version | Description |
|---|---|
| 9.0.0 (1912) | Sybase Adaptive Server Anywhere Windows NT |