in this blog we are going to see how to capture information about currently Installed SQL SERVER.
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)