How to view SQLSERVER version information and SP patch information

Open SQLSERVER Configuration Manager, double-click with the left mouse to open the Properties dialog box, and select the Advanced tab to view the SQL version information.

In the past, we often used the following statement to view the version information, SP version. Now we can double-click the mouse to see it. The most important thing is to make it easier for the customer to view the version information. There is no reason to ask the customer to write SQL statements.
Copy codeThe Code is as follows:
Select serverproperty ('version ')
Select serverproperty ('productlevel ')