TSQL to get SQL Server properties - How do I know which version of SQL Server I'm running?

Use the following TSQL SELECT SERVERPROPERTY('Collation') Collation, SERVERPROPERTY('Edition') Edition, SERVERPROPERTY('Engine Edition') EngineEdition, SERVERPROPERTY('InstanceName') InstanceName, SERVERPROPERTY('IsClustered') IsClustered, SERVERPROPERTY('IsFullTextInstalled') IsFullTextInstalled, SERVERPROPERTY('IsIntegratedSecurityOnly') IsIntegratedSecurityOnly, SERVERPROPERTY('IsSingleUser') IsSingleUser, SERVERPROPERTY('IsSyncWithBackup') IsSyncWithBackup, SERVERPROPERTY('LicenseType') LicenseType,...(<a href="http://sqlserver-qa.net/blogs/t-sql/archive/2007/12/21/2994.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=2994" width="1" height="1">