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)