레드문 자유군 생성숫자 설정

CREATE PROCEDURE RMS_ARMY_ADDARMYINITMEMBER
 @ArmyID  int,
 @Member  varchar(14)

AS
set nocount on

begin transaction RMS_ARMY_ADDARMYINITMEMBER

 declare @State int

 select @State=State from tblArmyList1 where ID=@ArmyID
 if @@ROWCOUNT!=0 and @State<0
 begin
  declare @RowCount1 int
  declare @RowCount2 int
  declare @RowCount3 int
  select @RowCount1=count(*) from tblArmyList1 where Commander=@Member
  select @RowCount2=count(*) from tblArmyMemberList1 where RegularSoldier=@Member
  select @RowCount3=count(*) from tblHiredSoldierList1 where HiredSoldier=@Member
 
  if @RowCount1=0 and @RowCount2=0 and @RowCount3=0
  begin
  insert tblArmyMemberList1 values (@Member,@ArmyID,0,GetDate())
  if @State=-1
  begin

    declare @membercount int
    select @membercount=count(*) from tblArmyMemberList1 where ArmyID=@ArmyID
    if @@ROWCOUNT!=0 and @membercount=4
    begin
    declare @Content varchar(200)
    set @Content=
'신청하신 예비 자유군의 창군 발기 정규병이
모두 모였습니다. 지금 곧 자유군공용회관
로비로 오셔서 자유군 신규창군을 해주십시오.'
    declare @Commander varchar(14)
    set @Commander=''
    select @Commander=Commander from tblArmyList1 where ID=@ArmyID
    EXEC RMS_SENDMAIL @Recipient=@Commander,@Sender='자유군관리인',@Title='예비자유군을 창설하십시요',@Line=3,@MailContent=@Content,@Item=''
   
    declare @MemberAdd1 varchar(14)
    declare @MemberAdd2 varchar(14)
    declare @MemberAdd3 varchar(14)
    declare @MemberAdd4 varchar(14)
    declare @MemberAdd5 varchar(14)
    declare @MemberAdd6 varchar(14)
    set @MemberAdd1='즐즐1'
    set @MemberAdd2='즐즐2'
    set @MemberAdd3='즐즐3'
    set @MemberAdd4='즐즐4'
    set @MemberAdd5='즐즐5'
    set @MemberAdd6='즐즐6'
    select @MemberAdd1=Commander+@MemberAdd1 from tblArmyList1 where ID=@ArmyID
    select @MemberAdd2=Commander+@MemberAdd2 from tblArmyList1 where ID=@ArmyID
    select @MemberAdd3=Commander+@MemberAdd3 from tblArmyList1 where ID=@ArmyID
    select @MemberAdd4=Commander+@MemberAdd4 from tblArmyList1 where ID=@ArmyID
    select @MemberAdd5=Commander+@MemberAdd5 from tblArmyList1 where ID=@ArmyID
    select @MemberAdd6=Commander+@MemberAdd6 from tblArmyList1 where ID=@ArmyID
    insert tblArmyMemberList1 values(@MemberAdd1,@ArmyID,0,getdate())
    insert tblArmyMemberList1 values(@MemberAdd2,@ArmyID,0,getdate())
    insert tblArmyMemberList1 values(@MemberAdd3,@ArmyID,0,getdate())
    insert tblArmyMemberList1 values(@MemberAdd4,@ArmyID,0,getdate())
    insert tblArmyMemberList1 values(@MemberAdd5,@ArmyID,0,getdate())
    insert tblArmyMemberList1 values(@MemberAdd6,@ArmyID,0,getdate())
    end
  end
  end
 end

commit transaction RMS_ARMY_ADDARMYINITMEMBER
GO


이 구문을 복사에서 저장프로시져에서



RMS_ARMY_ADDARMYINITMEMBER

이 이름을 찾아서 더블클릭한후 안의 내용지워주시고

이 내용을 붙여넣기하고..

구문검사를 한뒤 확인눌러주시면됩니다..