Question

how can you find Server Edition?

Answer

SELECT 'Edition', SERVERPROPERTY('Edition')

UNION ALL

SELECT 'EditionID', SERVERPROPERTY('EditionID')

UNION ALL

SELECT 'ProductVersion', SERVERPROPERTY('ProductVersion')

UNION ALL

SELECT 'ProductLevel', SERVERPROPERTY('ProductLevel')

UNION ALL

SELECT 'EngineEdition', SERVERPROPERTY('EngineEdition')

UNION ALL

SELECT 'ServerName', SERVERPROPERTY('ServerName')

OR

select @@version

Read More..   [32134 clicks]

Published under: SQL Server Interview Questions ·  ·  ·  ·