MSSQL 버전확인

1. 버전

SELECT @@VERSION

 

2. 서비스팩

SELECT SERVERPROPERTY('productlevel')

 

3. 버전, 서비스팩, 설치 Edition 확인

SELECT 'SQL Server '
+ CAST(SERVERPROPERTY('productversion') AS VARCHAR) + ' - '
+ CAST(SERVERPROPERTY('productlevel') AS VARCHAR) + ' ('
+ CAST(SERVERPROPERTY('edition') AS VARCHAR) + ')'