로그인처리
output 2개 사용 create proc MEM_LOGIN ( @mId varchar(12), @mPwd varchar(12), @errNum int output, @errText nvarchar(100) output ) as begin set @errNum = 0 set @errText = '정상' declare @cPwd varchar(12) select @cPwd=mPwd from member where mId=@mId if (@cPwd is null) begin set @errNum = 1 set @errText = '가입된 정보가 없습니다.' end else begin if(@mPwd != @cPwd) begin set @errNum = 2 set @errText = '비밀번호가 맞지 않습니..
청강컴정/09DataBase기말고사
2009. 5. 10. 01:01