CREATE PROCEDURE AddUnionBattle
e#vGrLs.
@time DATETIME,
e#vGrLs.
@state INT,
e#vGrLs.
@proc INT,
e#vGrLs.
@bt INT,
e#vGrLs.
@map INT,
e#vGrLs.
@req_uid INT,
e#vGrLs.
@req_name CHAR(16),
e#vGrLs.
@res_uid INT,
e#vGrLs.
@res_name CHAR(16)
e#vGrLs.
AS
e#vGrLs.
SET NOCOUNT ON
e#vGrLs.
DECLARE @ubid INT
e#vGrLs.
SELECT @ubid=MAX(ub_propid) FROM UnionBattle
e#vGrLs.
IF(@ubid IS NULL) SET @ubid=2000
e#vGrLs.
SET @ubid = @ubid+1
e#vGrLs.
INSERT UnionBattle( ub_propid, time_battle, ub_state, ub_proc, battle_type, battle_map, req_uid, req_uname, res_uid, res_uname) VALUES( @ubid, @time, @state, @proc, @bt ,@map, @req_uid, @req_name, @res_uid, @res_name)
e#vGrLs.
SELECT @ubid
e#vGrLs.
GO
e#vGrLs.