公交查询-获得直达车次

--获取直达车次
drop proc bus_qry
Go
create procedure bus_qry
  @Station_Start varchar(20),
  @Station_Stop varchar(20)
as
  set nocount on
  declare @l int
  set @l=0
select bn.*
  into # from Bus b
  inner join busNum bn on b.checi=bn.checi
  inner join station s on s.stationNum=b.stationNum
  where s.stationName=@Station_Start
  if @@rowcount>0
  begin
  select a.* into #1 from # a
 inner join bus b on a.checi=b.checi
 inner join station s on b.stationNum=s.stationNum
 where s.stationName=@station_Stop
  end
select * from #1
GO
exec Bus_qry '京广客运站','市骨科医院'
Go 

注:代码放上来望大家多多指正,小弟不胜感激