Returns version, processor architecture, builds date, and operating system for the current installation of SQL Server.
USAGE:
select @@version
Output:
Microsoft SQL Server 2005 - 9.00.4060.00 (X64)
Mar 17 2011 13:06:52
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.1
(Build 7601: Service Pack 1)