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