日期:2014-05-18  浏览次数:20419 次

是用 存储过程 还是 视图 ???
下面是查询公司的基本信息,是用存储过程好,还是视图好呢?
这一点很迷惑,希望大家多多指教。

select   comp_id,   comp_name,city_name+coun_name   as   address   ,comp_homepage,comp_email,comp_tel

from   tbl_company     comp

join
      (select   city_name,city_id   from   tbl_city)   city
on   comp.comp_address_city=city.city_Id

join  
      (select   coun_id,coun_name   from   tbl_country)   coun
on   comp.comp_address_county=coun.coun_id


------解决方案--------------------
除非你建索引视图,否则相当于只是保存了一个查询批