Check MSSQL version

SQL Server Management Studio 실행 – 새 쿼리

방법 1) select @@version;

방법 2) SELECT ‘SQL Server ‘+ CAST(SERVERPROPERTY(‘productversion’) AS VARCHAR) + ‘ – ‘+ CAST(SERVERPROPERTY(‘productlevel’) AS VARCHAR) + ‘ (‘+ CAST(SERVERPROPERTY(‘edition’) AS VARCHAR) + ‘)’

F5 누르기 ; 쿼리 실행