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...