新问题：每次进入游戏都要选择国家，而且同一个账号可以同时有兽族和人族的人物，怎么解决，谢谢！！！

把这个ACCOUNT_LOGIN存储过程改为如下：

1. CREATE PROCEDURE ACCOUNT_LOGIN
   
2. @AccountID        varchar(21),
   
3. @Password        varchar(13),
   
4. @nRet                smallint        OUTPUT
   
5. 
   
6. AS
   
7. 
   
8. 
   
9. DECLARE @Nation tinyint, @CharNum smallint
   
10. SET @Nation = 0
    
11. SET @CharNum = 0
    
12. 
    
13. DECLARE @pwd varchar(13)
    
14. 
    
15. SET @pwd = null
    
16. 
    
17. SELECT @pwd = strPasswd FROM [dbo].[TB_USER] WHERE strAccountID = @AccountID and idays=6
    
18. IF @pwd IS null
    
19. BEGIN
    
20.         SET @nRet = 0
    
21.              --SET @nRet = 4
    
22.         RETURN
    
23. END
    
24. 
    
25. ELSE IF @pwd <> @Password
    
26. BEGIN
    
27.         SET @nRet = 0
    
28.              --SET @nRet = 3
    
29.         RETURN
    
30. END
    
31. 
    
32. DECLARE @gokhantasci varchar(21)
    
33. select @gokhantasci = count(straccountid)  FROM premium_service WHERE strAccountID = @AccountID
    
34. 
    
35. if @gokhantasci = 0
    
36. begin
    
37. insert into PREMIUM_SERVICE (strAccountID, strType, nDays) VALUES (@AccountID, 1, 3)
    
38. end
    
39. 
    
40. SELECT @Nation = bNation, @CharNum = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
    
41. IF @@ROWCOUNT = 0
    
42. BEGIN
    
43.         SET @nRet = 1
    
44.         RETURN
    
45. END
    
46. IF @CharNum = 0
    
47. BEGIN
    
48.         SET @nRet = 1
    
49.         RETURN
    
50. END
    
51. ELSE
    
52. BEGIN
    
53.         SET @nRet = @Nation+1
    
54.              --SET @nRet = 1
    
55.         RETURN
    
56. END
    
57. GO

复制代码

按楼上的这样做了后，游戏输完账号和密码后就提示此服务器出现错误