check sql validation

Question

  this is my sp

 

CREATE PROCEDURE USP_LOGIN

(

@UNAME VARCHAR(100),@PASS VARCHAR(100)

)

AS

BEGIN

SET NOCOUNT ON;

IF EXISTS(SELECT *FROM TBL_LOGIN WHERE USERNAME= @UNAME AND PASWORD=@PASS)

PRINT 'LOGIN SUCCESFULLY'

ELSE

PRINT 'INCORRECT USERNAME OR PASSWORD'

END

 

how can i check a username and password validation