xp_msver (Transact-SQL)
Returns version information about Microsoft SQL Server. xp_msver also returns information about the actual build number of the server and information about the server environment. The information that xp_msver returns can be used within Transact-SQL statements, batches, stored procedures, and so on, to enhance logic for platform-independent code.
Transact-SQL Syntax Conventions
Składnia
xp_msver [ optname ]
Arguments
optname
Is the name of an option, and can be one of the following values.Option/Column name
Description
ProductName
Product name; for example, Microsoft SQL Server.
ProductVersion
Product version.
Language
The language version of SQL Server.
Platform
Operating-system name, manufacturer name, and chip family name for the computer that is running SQL Server.
Comments
Miscellaneous information about SQL Server.
CompanyName
Company name that produces SQL Server; for example, Microsoft Corporation.
FileDescription
The operating system.
FileVersion
Version of the SQL Server executable.
InternalName
Microsoft internal name for SQL Server; for example, SQLSERVR.
LegalCopyright
Legal copyright information required for SQL Server; for example, Copyright© Microsoft Corp. 1988-2005.
LegalTrademarks
Legal trademark information required for SQL Server. For example, Microsoft is a registered trademark of Microsoft Corporation.
OriginalFilename
File name executed at SQL Server startup; for example, Sqlservr.exe.
PrivateBuild
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
SpecialBuild
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
WindowsVersion
Version of Microsoft Windows that is installed on the computer that is running SQL Server.
ProcessorCount
The number of processors in the computer that is running SQL Server.
ProcessorActiveMask
Indicates the processors installed in the computer that is running SQL Server that are started and usable by Microsoft Windows.
ProcessorType
Processor type. Similar to Platform.
PhysicalMemory
Amount in megabytes (MB) of RAM installed on the computer that is running SQL Server.
Product ID
Product ID (PID) number. This is specified during installation. This number is located on a sticker on the original SQL Server CD case.
Return Code Values
1 (success)
Result Sets
xp_msver, without any parameters, returns a four-column result set that lists all the option values. xp_msver, for any parameter, returns the four-column result set with values for that option.
Permissions
Requires membership in the public role.
Zobacz także
Odwołanie
System Functions (Transact-SQL)
System Stored Procedures (Transact-SQL)