| 修改ACCOUNT_LOGIN这个储存过程 CREATE PROCEDURE ACCOUNT_LOGIN
 @AccountID varchar(21),
 @Password varchar(13),
 @nRet smallint OUTPUT
 
 AS
 
 
 DECLARE @Nation tinyint
 SET @Nation = 0
 -- tid login method by samma 2004.02.24
 DECLARE @pwd varchar(13)
 
 SET @pwd = null
 
 SELECT @pwd = strPasswd FROM TB_USER WHERE strAccountID = @AccountID
 IF @pwd IS null
 BEGIN
 SET @nRet = 0
 RETURN
 END
 
 ELSE IF @pwd <> @Password
 BEGIN
 SET @nRet = 0
 RETURN
 END
 
 SELECT @Nation = bNation FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
 IF @@ROWCOUNT = 0
 BEGIN
 SET @nRet = 1
 RETURN
 END
 BEGIN
 SET @nRet = 1
 RETURN
 END
 BEGIN
 SET @nRet = @Nation+1
 RETURN
 END
 GO
 修改成这样
 |