請教各位以下問題~^^


以下是我執行的末日司令騎馬存儲

1. CREATE PROCEDURE WAR_CAPITAN
   
2. @UserId varchar(21),
   
3. @Nrow int
   
4. AS DECLARE @Race int,@Nation int
   
5. 
   
6. Select @Race = Race From USERDATA Where strUserId = @UserId
   
7. Select @Nation = Nation From USERDATA Where strUserId = @UserId
   
8. 
   
9. --Ata Bin IF @Race = 1 and @Nrow = 1
   
10. BEGIN Update USERDATA Set Race = 5 Where strUserId = @UserId
    
11. END   
    
12. ELSE IF @Race = 2 and @Nrow = 1
    
13. BEGIN Update USERDATA Set Race = 6 Where strUserId = @UserId
    
14. END   
    
15. ELSE IF @Race = 3 and @Nrow = 1
    
16. BEGIN Update USERDATA Set Race = 7 Where strUserId = @UserId
    
17. END   
    
18. ELSE IF @Race = 4 and @Nrow = 1
    
19. BEGIN Update USERDATA Set Race = 8 Where strUserId = @UserId
    
20. END   
    
21. ELSE IF @Race = 11 and @Nrow = 1
    
22. BEGIN Update USERDATA Set Race = 14 Where strUserId = @UserId
    
23. END
    
24. ELSE IF @Race = 12 and @Nrow = 1
    
25. BEGIN Update USERDATA Set Race = 15 Where strUserId = @UserId
    
26. END
    
27. ELSE IF @Race = 13 and @Nrow = 1
    
28. BEGIN Update USERDATA Set Race = 16 Where strUserId = @UserId
    
29. END
    
30. --Attan In
    
31. IF @Race = 5 and @Nrow = 2
    
32. BEGIN Update USERDATA Set Race = 1 Where strUserId = @UserId
    
33. END   
    
34. ELSE IF @Race = 6 and @Nrow = 2
    
35. BEGIN Update USERDATA Set Race = 2 Where strUserId = @UserId
    
36. END   
    
37. ELSE IF @Race = 7 and @Nrow = 2
    
38. BEGIN Update USERDATA Set Race = 3 Where strUserId = @UserId
    
39. END   
    
40. ELSE IF @Race = 8 and @Nrow = 2
    
41. BEGIN Update USERDATA Set Race = 4 Where strUserId = @UserId
    
42. END   
    
43. ELSE IF @Race = 14 and @Nrow = 2
    
44. BEGIN Update USERDATA Set Race = 11 Where strUserId = @UserId
    
45. END
    
46. ELSE IF @Race = 15 and @Nrow = 2
    
47. BEGIN Update USERDATA Set Race = 12 Where strUserId = @UserId
    
48. END
    
49. ELSE IF @Race = 16 and @Nrow = 2
    
50. BEGIN Update USERDATA Set Race = 13 Where strUserId = @UserId
    
51. END
    
52. 
    
53. GO
    
54. 
    
55. Go to Update_User_Data and look for
    
56. 
    
57. WHERE    strUserId    = @id and add this :
    
58. DECLARE @Neo int
    
59. Select @Neo = Count(*) From USERDATA Where Zone = @Zone
    
60. 
    
61. IF @Zone = 102 and @Nation = 1 and @Neo < 6
    
62. BEGIN Exec WAR_CAPITAN @id , '1'
    
63. END
    
64. ELSE IF @Zone = 102 and @Nation = 2 and @Neo < 6
    
65. BEGIN Exec WAR_CAPITAN @id , '1'
    
66. END

复制代码

run this to execute :
Exec WAR_CAPITAN 'Ingame Name' ,'1'

Exec WAR_CAPITAN 'Ingame Name','2'

以下是出現的錯誤訊息

/*-----------------------------
CREATE PROCEDURE WAR_CAPITAN
@UserId varchar(21),
@Nrow int
-----------------------------*/
Server: Msg 156, Level 15, State 1, Procedure WAR_CAPITAN, Line 12
在关键字 'ELSE' 附近有语法错误。
Server: Msg 156, Level 15, State 1, Line 2
在关键字 'to' 附近有语法错误。
Server: Msg 137, Level 15, State 1, Line 6
必须声明变量 '@Zone'。
Server: Msg 137, Level 15, State 1, Line 8
必须声明变量 '@Zone'。
Server: Msg 137, Level 15, State 1, Line 9
必须声明变量 '@id'。
Server: Msg 137, Level 15, State 1, Line 11
必须声明变量 '@Zone'。
Server: Msg 137, Level 15, State 1, Line 12
必须声明变量 '@id'。

請問toto 可否發給我完整的存儲或指導一下要增加那些數據?  謝謝

sql存储过程有问题，检查一下哪里语法不对，或者是不是使用了非英文的字符。

这个问题。。。是个问题