到底哪里出错了?
xy328 2001-08-17 12:34:12 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,
AS
if exists (select IPPacketSerial from Traffic
where IPPacketSerial = @IPPacketSerial)
begin
update Traffic set Date_len = Date_len + @Date_len , [end] = @end
where IPPacketSerial = @IPPacketSerial
end
else
begin
insert Traffic (Start,endtime,Serial_no,Src_add,Src_port,Dst_addr,Dst_port,Date_len,IPPacketSerial)
values(@Start,@endtime,@Serial_no,@Src_add,@Src_port,@Dst_addr,@Dst_port,@Date_len,@IPPacketSerial)
end
我用SQL Server Query Analyzer 调用这个存储过程的语句是
UpdateTraffic('20:01:00','20:01:01',
'58612885','192.168.1.111','2000','192.168.1.166',
'2000',30,1)
为什么会出错?
错误提示是
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '20:01:00'.
即便是我把时间换成 '2001-11-12 20:11:00'这种格式也不对,请问这究竟是怎么回事?