| 你试一下 这个 在 储存过程那里 点新建  然后把下面的 代码粘贴进去!!!
 CREATE PROCEDURE MGAME_LOGIN
 @AccountID        varchar(21),
 @Password        varchar(13),
 @nRet                smallint        OUTPUT
 
 AS
 
 
 DECLARE @Nation tinyint, @CharNum smallint
 SET @Nation = 0
 SET @CharNum = 0
 
 DECLARE @pwd varchar(13)
 
 SET @pwd = null
 
 SELECT @pwd = strPasswd FROM [dbo].[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, @CharNum = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
 IF @@ROWCOUNT = 0
 BEGIN
 SET @nRet = 1
 RETURN
 END
 IF @CharNum = 0
 BEGIN
 SET @nRet = 1
 RETURN
 END
 ELSE
 BEGIN
 SET @nRet = @Nation+1
 RETURN
 END
 GO
 |