Ò»¸ö¹ØÓÚSQLµÄ¼òµ¥ÎÊÌâ

create proc Login
as
declare @aa varchar(20),
@num varchar(20),
@date datetime,
@loginType varchar(20),
@loginIp varchar(20)
set @aa=(select userId from t_UserInfo where zhzNum=@num or mobileNo=@num)
if @aa=null
  set @@error=1
else
  set @@error=0
set @date=getdate()
insert t_userLogin(userid,userLoginTime,loginType,loginIp) values(@aa,@date,@loginType,@loginIp)
if @@error <>0
return 1
else
return 0
Ôõô´íÁËÄØ£¬´ó»ï¿´¿´¡£ÎÒÖªµÀÎÒдµÄ²»ºÃ£¬´ó»ï¿´¿´Äܲ»ÄÜÄÄÀï¸Ä½øÏ£¬Ð»Ð»¡£

---

@aa=null  ÊDz»ÊÇ @aa is null

---

set @aa=(select userId from t_UserInfo where zhzNum=@num or mobileNo=@num)
select @aa=userid from t_userinfo where zhzNum=@num or mobileNo=@num

---

µÈ³Ô·¹£¡£¡

---

@aa varchar(20),
@num varchar(20),
@date datetime,
@loginType varchar(20),
@loginIp varchar(20)
ÕâЩ²ÎÊý¸Ã·ÅASÇ°Ãæ°É~~~

---

»¹ÊDz»¶Ô°¡£¬'@@error' ¸½½üÓÐÓï·¨´íÎó¡£

---

@@error ²»ÄÜÉèÖÃ

---

ÄÇÔõôÓÃÄØ£¬ÎÒÉÏÃæµÄSQLÓï¾ä¸ÃÔõô¸Ä°¡

---

϶αàÒëûÓÐÎÊÌâ
SQL code:
create proc Login
@returnValue int OUTPUT
as
declare @aa varchar(20),
@num varchar(20),
@date datetime,
@loginType varchar(20),
@loginIp varchar(20),
@errorCount int