修改存储过程强制使其的时间格式一致:
---------------------
CREATE PROCEDURE SearchFlight
(
@sStartingFrom varchar(50),
@sDestination varchar(50),
@dArrivalDate datetime,
@dDepartureDate datetime,
@iTravelClassID int
)
AS
begin
set nocount on
select F.* from flights F
inner join travel_class_seat_capacity TCSC
on TCSC.flight_ID=F.flight_ID
inner join travel_class TC
on TC.travel_class_ID=TCSC.travel_class_ID
where F.starting_from=@sStartingFrom
and F.destination=@sDestination
and convert(varchar(30),F.arrival_date,103)=convert(varchar(30),@dArrivalDate,103)
and convert(varchar(30),F.departure_date,103)=convert(varvhar(30),@dDepartureDate,103)
and TC.travel_class_ID=@iTravelClassID
and TCSC.number_of_seats>0
end
GO--------------------
哈哈~~~过年了.多蹭点分回家罗~~~
灌水~~~
---------------------
CREATE PROCEDURE SearchFlight
(
@sStartingFrom varchar(50),
@sDestination varchar(50),
@dArrivalDate datetime,
@dDepartureDate datetime,
@iTravelClassID int
)
AS
begin
set nocount on
select F.* from flights F
inner join travel_class_seat_capacity TCSC
on TCSC.flight_ID=F.flight_ID
inner join travel_class TC
on TC.travel_class_ID=TCSC.travel_class_ID
where F.starting_from=@sStartingFrom
and F.destination=@sDestination
and convert(varchar(30),F.arrival_date,103)=convert(varchar(30),@dArrivalDate,103)
and convert(varchar(30),F.departure_date,103)=convert(varvhar(30),@dDepartureDate,103)
and TC.travel_class_ID=@iTravelClassID
and TCSC.number_of_seats>0
end
GO--------------------
哈哈~~~过年了.多蹭点分回家罗~~~
灌水~~~
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货