Issue: How to use query to find the Microsoft SQL version and Service pack for SQL?

I wanted to know how to find the service pack version installed on my SQL server. I foudn the following query that gives details of it.

Solution:

Open the SQL Management studio and run the below query.

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')