[Five Methods] SqlServer_ View SQL server version information

Method 1

Execute SQL statement

SELECT @@VERSION

Method 2

Connect to SQL Server Management Studio and use the main version number information displayed by object explorer to display the current instance product version number 11.0.6020

Method 3

Look at the agent log

Method 4

In SQL Server Management Studio, by executing [sys]. [XP]_ Msver] to get the version number information

[sys].[xp_msver]

Method 5

SELECT   
 SERVERPROPERTY('servername') AS 实例名,  
 SERVERPROPERTY('ProductVersion') AS 实例版本,  
 SERVERPROPERTY('Edition') AS 产品版本,  
 SERVERPROPERTY('ProductLevel') AS 版本级别,  
 @@VERSION AS 版本信息

Similar Posts: