Kod:
CREATE PROCEDURE WAR_CAPITAN @userid varchar(21), @Nrow int AS DECLARE @race int @Nation int Select @race = Race From USERDATA Where strUserId = @userid Select @Nation = Nation From USERDATA Where strUserId = @userid --Ata Bin IF @race = 1 and @Nrow = 1 BEGIN Update USERDATA Set Race = 5 Where strUserId = @userid END ELSE IF @race = 2 and @Nrow = 1 BEGIN Update USERDATA Set Race = 6 Where strUserId = @userid END ELSE IF @race = 3 and @Nrow = 1 BEGIN Update USERDATA Set Race = 7 Where strUserId = @userid END ELSE IF @race = 4 and @Nrow = 1 BEGIN Update USERDATA Set Race = 8 Where strUserId = @userid END ELSE IF @race = 11 and @Nrow = 1 BEGIN Update USERDATA Set Race = 14 Where strUserId = @userid END ELSE IF @race = 12 and @Nrow = 1 BEGIN Update USERDATA Set Race = 15 Where strUserId = @userid END ELSE IF @race = 13 and @Nrow = 1 BEGIN Update USERDATA Set Race = 16 Where strUserId = @userid END --Attan İn IF @race = 5 and @Nrow = 2 BEGIN Update USERDATA Set Race = 1 Where strUserId = @userid END ELSE IF @race = 6 and @Nrow = 2 BEGIN Update USERDATA Set Race = 2 Where strUserId = @userid END ELSE IF @race = 7 and @Nrow = 2 BEGIN Update USERDATA Set Race = 3 Where strUserId = @userid END ELSE IF @race = 8 and @Nrow = 2 BEGIN Update USERDATA Set Race = 4 Where strUserId = @userid END ELSE IF @race = 14 and @Nrow = 2 BEGIN Update USERDATA Set Race = 11 Where strUserId = @userid END ELSE IF @race = 15 and @Nrow = 2 BEGIN Update USERDATA Set Race = 12 Where strUserId = @userid END ELSE IF @race = 16 and @Nrow = 2 BEGIN Update USERDATA Set Race = 13 Where strUserId = @userid END GO
[ir Teşekkur Yeter[