地铁站点查询 2011-3-7

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

 

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