memberLogin

create proc memberLogin
(
 @mID varchar(20),
 @mPwd varchar(20),
 @mChk int output
)
as
begin
 declare @tempPwd varchar(20)

 if(exists(select * from member where mID = @mID))
 begin
  if((select mPwd from member where mID=@mID) = @mPwd)
   set @mChk = 0
  else
   set @mChk = 2
 end
 else
  set @mChk = 1
end