Sometimes, we might not know the version,
edition etc of our installed SQL Server. We can follow anyone of the below
method to get that information:
1. Run Select @@version
within SQL Server Management Studio. It may show result similar to below:
Microsoft SQL Server 2008 R2 (RTM) -
10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft
Corporation Express Edition on Windows NT 6.1 <X86> (Build 7601: Service Pack
1)
This query returns information about the
product, such as version, product level, 64-bit versus 32-bit, the edition of
SQL Server etc.
2. Run SELECT
SERVERPROPERTY('productversion'), SERVERPROPERTY ('edition'), SERVERPROPERTY ('productlevel'),
it shows result similar to below:
10.50.1600.1 Express Edition RTM
The difference between above two queries is,
SERVERPROPERTY() returns individual selected properties where
as @@version combines all properties into one string and
returns it.