5times validation

Question

 hi friends 

 

i dont know how to write a query help me

when user enter wrong password 5 times    is wiill be locked 

sp below 

 

ALTER PROCEDURE CHK_UNAME_PASS

(

@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

BEGIN

PRINT 'INCORRECT USERNAME OR PASSWORD'

END

END

EXECUTE CHK_UNAME_PASS @UNAME='NANDHA',@PASS='101';