check in sql record is exits or not

How to check in sql record is exits (available) ?

Here give the Example of User Name is already taken by other user ?

Create Proc CheckUserNameExits

      @UserName varchar(20),

      @Result varchar(50) output

AS

BEGIN

      IF EXISTS (Select ID From UserMaster Where UserName=@UserName )     

            BEGIN      

                  SET   Result= 'User Name Is already Exits'     

            END

      ELSE

            BEGIN      

                  SET @Result= 'User Name Is not Exits'     

            END

      END

     

END

How to Call this Stored Procedure

string strStatus = "";

            this.DataContext.spInsertInOutTimeFromLoginPage(UserID, type, ref strStatus, ExtraTime, Initials);

            return strStatus;

In strStatus you get output from your Stored Procedure

Note : strStatus must be pass with ‘ref’ keyword