TSQL - 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


Fig 1: Output of @@version on SQL Server 2008 R2


Fig 2: Output of @@Version on SQL Server 2012