Retrieves version and name information about the database server.
Syntaxxp_msver( the_option )
Argumentsthe_option The string must be one of the following, enclosed in string delimiters.
| Argument | Description | ||
|---|---|---|---|
| ProductName | The name of the product (SQL Anywhere). | ||
| ProductVersion |
The version number, followed by the build number. The format is as follows:
|
||
| CompanyName |
Returns the following string:
|
||
| 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. |
Remarksxp_msver returns product, company, version, and other information.
PermissionsNone
See also ExampleThe following statement requests the version and operating system description:
SELECT xp_msver( 'ProductVersion') Version, xp_msver( 'FileDescription' ) Description; |
Sample output is as follows. The value for Version will likely be different on your system.
| Version | Description |
|---|---|
| 12.0.0.2413 | SQL Anywhere Windows XP |
 |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |