Command to get the version of SQL Server?

Hello Kiran,

Please refer  - https://www.c-sharpcorner.com/article/query-to-find-sql-server-version/

To get the version of SQL Server, you can use one of the following commands or queries:

-- Method-1 (returns a single-line)
SELECT @@VERSION;


-- Method-2 (returns detail Information)
SELECT 
    SERVERPROPERTY('ProductVersion') AS 'Product Version',
    SERVERPROPERTY('ProductLevel') AS 'Product Level', -- RTM, SP1, SP2, etc.
    SERVERPROPERTY('Edition') AS 'Edition', -- e.g., Enterprise, Standard, Developer
    SERVERPROPERTY('MachineName') AS 'Machine Name',
    SERVERPROPERTY('InstanceName') AS 'Instance Name';