Tagged: SQL Server Version

Finding Version in SQL Server

Hello everyone, In this article, you will learn about learning version information in SQL Server. You can learn your SQL Server version information by using the code below. SELECT CAST(SUBSTRING( CAST(SERVERPROPERTY(‘productversion’) AS VARCHAR(20)), 1, CHARINDEX(‘.’, CAST(SERVERPROPERTY(‘productversion’) AS VARCHAR(20))) – 1 ) AS INT); When you run the above code, you...

Don`t copy text!