Find version of SQLSERVER
We often want to know about the version we are using. There are few simple ways to get the version you are on.
1. Simplest way:
SELECT @@version
2. Right click on the SQL Server instance name in SSMS and select Properties
3. Use the SERVERPROPERTY function to get details about the version of SQL Server.