To know version of SQL by query

SELECT SERVERPROPERTY('ProductVersion');