How to solve this error?

Question

Hi i have created stored procedure for user login but it throws error..can any one help me out..

Create Table Tbl_Login(T_Id Int Identity(1,1),Mode Varchar(50),UserName Varchar(50),[PassWord] Varchar(50));

Select * From Tbl_Login;

Truncate Table Tbl_Login;

Drop Table Tbl_Login;

/*Stored procedure for User_Login*/

Create Proc SP_Login(@Mode Varchar(50),@Name Varchar(50),@PassWord Varchar(50,@Res INTEGER Output)
as
if exists(Select Mode,UserName,[PassWord] From Tbl_Login Where Mode=@Mode and UserName=@Name and [PassWord]=@PassWord)
set @Res=1
else
set @Res=0
go
Exec Proc SP_Login


Error:

Msg 102, Level 15, State 1, Procedure SP_Login, Line 1
Incorrect syntax near '@Res'.
Msg 137, Level 15, State 2, Procedure SP_Login, Line 3
Must declare the scalar variable "@PassWord".
Msg 137, Level 15, State 1, Procedure SP_Login, Line 4
Must declare the scalar variable "@Res".
Msg 137, Level 15, State 1, Procedure SP_Login, Line 6
Must declare the scalar variable "@Res".
Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'Proc'.

Answer 1

hi,

Agree with Anupam Singh, you forgot the close braces before @res variable.

Answer 2

Closing bracket is missing correct it.

Create Proc SP_Login(@Mode Varchar(50),@Name Varchar(50),@PassWord Varchar(50),@Res INTEGER Output)

Answer 3

Hi selva,,

Try this :

Create Proc SP_Login(@Mode Varchar(50),@Name Varchar(50),@PassWord Varchar(50),@Res INTEGER Output)

as 

if exists(Select Mode,UserName,[PassWord] From Tbl_Login Where Mode=@Mode and UserName=@Name and [PassWord]=@PassWord)

set @Res=1

else 

set @Res=0

go

I have highlighted where you were wrong.