CREATE PROCEDURE AddUnionBattle
#*"5F*
@time DATETIME,
#*"5F*
@state INT,
#*"5F*
@proc INT,
#*"5F*
@bt INT,
#*"5F*
@map INT,
#*"5F*
@req_uid INT,
#*"5F*
@req_name CHAR(16),
#*"5F*
@res_uid INT,
#*"5F*
@res_name CHAR(16)
#*"5F*
AS
#*"5F*
SET NOCOUNT ON
#*"5F*
DECLARE @ubid INT
#*"5F*
SELECT @ubid=MAX(ub_propid) FROM UnionBattle
#*"5F*
IF(@ubid IS NULL) SET @ubid=2000
#*"5F*
SET @ubid = @ubid+1
#*"5F*
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-5, @state, @proc, @bt ,@map, @req_uid, @req_name, @res_uid, @res_name)
#*"5F*
SELECT @ubid
#*"5F*
GO
把那个删了,然后在查询分析器里面运行上面这个
就OK了