---------------------------------------------------------------------------------
Returns version, processor architecture, build date, and operating system for the current installation of SQL Server.

SELECT @@VERSION AS 'SQL Server Version'

Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86)   Mar 23 2007 16:28:52   Copyright (c) 1988-2005 Microsoft Corporation  Developer Edition on Windows NT 6.0 (Build 6000: ) 
---------------------------------------------------------------------------------