Comments by Member 11199447 (Top 2 by date)

Member 11199447 30-Sep-20 5:28am View

I have more to code in login procedure to make it real application and applicable in real world but now i need to be focus in this issue.

Member 11199447 30-Sep-20 4:30am View

Sir, Actuall Sql Server code is

ALTER PROC [dbo].[spCheckLogin]
@userName VARCHAR(20),
@PassCode VARCHAR(20),
@ErrorPrint varchar(200) OUT
AS
IF EXISTS ( SELECT TOP 1 * FROM UserTable WHERE UserName=@userName AND IsBlocked=1)
BEGIN
SET @ErrorPrint= 'Your account is blocked. Contact administrator'
END

ELSE
BEGIN
SELECT TOP 1 * FROM UserTable WHERE UserName=@userName and PassCode=@PassCode

First i need to solve Out Parameter problem.There is more to code in this procedure