1
hi,
Agree with Anupam Singh, you forgot the close braces before @res variable.
1
Closing bracket is missing correct it.
Create Proc SP_Login(@Mode Varchar(50),@Name Varchar(50),@PassWord Varchar(50),@Res INTEGER Output)
1
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.