谢谢ＣＴ的存储过程　ACCOUNT_LOGIN，十分感谢。
问题已找到，对应的ＴＢ＿ＵＳＥＲ表里缺项了，补全了就可以执行该存储了。

1. [code]CREATE PROCEDURE ACCOUNT_LOGIN
   
2. @AccountID varchar(21),
   
3. @Password varchar(13),
   
4. @nRet smallint OUTPUT
   
5. 
   
6. AS
   
7. select @nRet = count(straccountid) from tb_user where straccountid = @AccountID
   
8. if @nRet = 0
   
9. begin
   
10.    RETURN
    
11. end
    
12. 
    
13. 
    
14. select @nRet = strAuthority from tb_user where straccountid = @AccountID
    
15. if @nRet = 255
    
16. begin
    
17. set @nRet=4
    
18. return
    
19. end
    
20. 
    
21. 
    
22. DECLARE @Nation tinyint, @CharNum smallint
    
23. SET @Nation = 0
    
24. SET @CharNum = 0
    
25. 
    
26. DECLARE @pwd varchar(13)
    
27. set @pwd=null
    
28. SELECT @pwd = strPasswd FROM [dbo].[TB_USER] WHERE strAccountID = @AccountID  and  idays>0
    
29. IF @pwd IS null
    
30. BEGIN
    
31. --SET @nRet = 0
    
32.         SET @nRet = 4
    
33. RETURN
    
34. END
    
35. ELSE IF @pwd <> @Password
    
36. BEGIN
    
37. --SET @nRet = 0
    
38.         SET @nRet = 3
    
39. RETURN
    
40. END
    
41. 
    
42. 
    
43. SELECT @Nation = bNation, @CharNum = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
    
44. IF @@ROWCOUNT = 0
    
45. BEGIN
    
46. SET @nRet = 1
    
47. RETURN
    
48. END
    
49. IF @CharNum = 0
    
50. BEGIN
    
51. SET @nRet = 1
    
52. RETURN
    
53. END
    
54. ELSE
    
55. BEGIN
    
56. SET @nRet = @Nation+1
    
57.         END
    
58. DECLARE @premiumExpire datetime,@nDays int
    
59. DELETE FROM PREMIUM_SERVICE WHERE strAccountID = @AccountID
    
60. SELECT @premiumExpire=premiumExpire FROM TB_USER WHERE strAccountID = @AccountID
    
61. IF @premiumExpire IS NOT NULL
    
62. BEGIN
    
63.         SET @nDays = DateDiff(d, getDate(), @premiumExpire)
    
64.         IF @nDays>0
    
65.                 INSERT INTO PREMIUM_SERVICE(strAccountID,strType,nDays) VALUES(@AccountID,4,@nDays)
    
66. END
    
67. GO
    

复制代码

[/code]

为什么直接进艾莫尔的界面呢？没有s的

恩 能不能设成第一次进去的时候可以选种族 然后再登录的时候就不用了

謝謝.

为什么新创建的存储过程会提示有语法错误呢。。我用的SQL2000..

能看到图片么？

&#304; liked this procedure