CREATE PROCEDURE AddUnionBattle
9+qOP>m
@time DATETIME,
9+qOP>m
@state INT,
9+qOP>m
@proc INT,
9+qOP>m
@bt INT,
9+qOP>m
@map INT,
9+qOP>m
@req_uid INT,
9+qOP>m
@req_name CHAR(16),
9+qOP>m
@res_uid INT,
9+qOP>m
@res_name CHAR(16)
9+qOP>m
AS
9+qOP>m
SET NOCOUNT ON
9+qOP>m
DECLARE @ubid INT
9+qOP>m
SELECT @ubid=MAX(ub_propid) FROM UnionBattle
9+qOP>m
IF(@ubid IS NULL) SET @ubid=2000
9+qOP>m
SET @ubid = @ubid+1
9+qOP>m
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)
9+qOP>m
SELECT @ubid
9+qOP>m
GO
9+qOP>m