Best way to create [CheckUserNameAvailability] Strored procedure

Hello friends, As we know in all our projects we have [CheckUserNameAvailability] SP in which check user availability at the time of registration

CREATE PROCEDURE [CheckUserNameAvailability] @UserName VARCHAR(30)
AS 
    BEGIN
        SET NOCOUNT ON 
        
        IF EXISTS ( SELECT  1
                    FROM    Users
                    WHERE   UserName = @UserName ) 
            SELECT  '1'
        ELSE 
            SELECT  '0'
            
        SET NOCOUNT OFF             
    END
GO

Thanks

Rahul