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