地铁站点查询 2011-3-7

create proc proc_subtitle
(
   @stname varchar(20),
   @sc_id int
)
as
select ta.sl_id,ta.ss_station_name from(
select * from subway_station where  ss_station_name like '%'+@stname+'%') as ta
inner join subway_line as tb on ta.sl_id=tb.sl_id and tb.sc_id=@sc_id

 

2011-3-7 根据站点名称、城市id，查询地铁站点列表。模糊查询。