It is quite common to get the SQL Server version details from following query.
SELECT @@VERSION VersionInfo
Recently I have been using following SP to get version details as it also provides me few more information about the server where the SQL Server is installed.
Watch a 60 second video on this subject
I like to use the second one but again that is my preference.
Reference: Pinal Dave (http://blog.SQLAuthority.com)