请问哪里错了???
xy328 2001-08-17 02:57:18 CREATE PROCEDURE UpdateTraffic
@Start datetime,
@endtime datetime,
@Serial_no varchar(50),
@Src_add varchar(50),
@Src_port varchar(50),
@Dst_addr varchar(50),
@Dst_port varchar(50),
@Date_len int,
@IPPacketSerial int,
@Data binary,
@Flag bit
AS
if not exists (select IPPacketSerial from Traffic
where IPPacketSerial = @IPPacketSerial)
begin
if @Flag
begin
insert Traffic (Start,endtime,Serial_no,Src_add,Src_port,Dst_addr,Dst_port,Date_len,IPPacketSerial,Data)
values(@Start,@endtime,@Serial_no,@Src_add,@Src_port,@Dst_addr,@Dst_port,@Date_len,@IPPacketSerial,@Data)
end
else
begin
insert Traffic (Start,endtime,Serial_no,Src_add,Src_port,Dst_addr,Dst_port,Date_len,Data)
values(@Start,@endtime,@Serial_no,@Src_add,@Src_port,@Dst_addr,@Dst_port,@Date_len,@Data)
end
end
else
begin
if @Flag
begin
update Traffic set Date_len = Date_len + @Date_len , endtime = @endtime
where IPPacketSerial = @IPPacketSerial
end
else
begin
update Traffic set Date_len = Date_len + @Date_len , endtime = @endtime , IPPacketSerial = null
where IPPacketSerial = @IPPacketSerial
end
end
提示说我的错误在 begin,else ,begin else 附近。请问哪里错了?