SQL Server instance startup type check by SQL script

-- 2021-12-24, Developed by Vincent Jiang.

SET NOCOUNT ON;

DECLARE @SQLServerStartupMode1 [int],
        @SQLServerStartupMode2 [int],
        @SQLServerStartupType [char] (256),
        @SQLServerRegistryKeyPath [varchar] (256)


IF SERVERPROPERTY('InstanceName') IS NULL -- Default Instance
BEGIN --default instance
    SET @SQLServerRegistryKeyPath = 'SYSTEMCurrentControlSETSERVICESMSSQLSERVER'
END
ELSE
BEGIN --Named Instance
    SET @SQLServerRegistryKeyPath = 'SYSTEMCurrentControlSETSERVICESMSSQL$' + CAST(SERVERPROPERTY('InstanceName') AS [sysname])

END
 
EXEC [master]..[xp_regread] 'HKEY_LOCAL_MACHINE'
    ,@SQLServerRegistryKeyPath
    ,@value_name = 'DelayedAutostart'
    ,@value = @SQLServerStartupMode1 OUTPUT
 
EXEC [master]..[xp_regread] 'HKEY_LOCAL_MACHINE'
    ,@SQLServerRegistryKeyPath
    ,@value_name = 'Start'
    ,@value = @SQLServerStartupMode2 OUTPUT
 

SET @SQLServerStartupType = (
        SELECT 'Start Up Mode' = CASE
                WHEN @SQLServerStartupMode1 = 1 and @SQLServerStartupMode2 = 2
                    THEN 'Automatic(Delayed Start)'
                WHEN @SQLServerStartupMode1 = 0 and @SQLServerStartupMode2 = 2
                    THEN 'Automatic'
                WHEN @SQLServerStartupMode2 = 2
                    THEN 'Automatic'
                WHEN @SQLServerStartupMode2 = 3
                    THEN 'Manual'
                WHEN @SQLServerStartupMode2 = 4
                    THEN 'Disabled'
                END
        )

 
SELECT @SQLServerStartupType AS SQLServerStartupType