How To Find Version of SQL Server

How To Find Version of SQL Server

 

SQL Server provide built in functions those are helpful to provide us different information related to SQL server such as Version, SQL Server Name etc.

We can use @@Version to get the version information of SQL Server. I have executed below Query on SQL server 2008 and SQL Server 2012.

SELECT @@VERSION

 

SELECT @@Servername