sql server check version
snippet in sql

sql version query

user5274

SELECT @@VERSION AS 'SQL Server Version';  

sql server check version

user4829

SELECT @@version