How to determine SQL version

Simple query:  select @@version

Or: SELECT SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition'), @@version

Detailed methods:  https://www.mssqltips.com/sqlservertip/1140/how-to-tell-what-sql-server-version-you-are-running/