發表文章

目前顯示的是 10月, 2014的文章

Cisco ASA5520設定

 Cisco ASA 5500-X Series Next-Generation Firewalls Configuration Guides http://www.cisco.com/c/en/us/support/security/asa-5500-series-next-generation-firewalls/products-installation-and-configuration-guides-list.html Configuring Interfaces (Transparent Mode) http://www.cisco.com/c/en/us/td/docs/security/asa/asa84/configuration85/guide/asa_cfg_cli_85/interface_complete_transparent.html Adding an IPv6 Access List http://www.cisco.com/c/en/us/td/docs/security/asa/asa82/configuration/guide/config/acl_ipv6.html Cisco guide document http://www.cisco.com/c/en/us/td/docs/security/asa/asa72/configuration/guide/conf_gd/intro.html ASA5520 compare http://www.cisco.com/web/HK/promotion_tc/asa5500_compare.html windows7 使用超級終端機連接RS232 COM1 PORT的3種方法 http://s90304a123.pixnet.net/blog/post/38498867 ASA password recovery https://supportforums.cisco.com/document/79016/asa-password-recovery Howto reset factory defaults Cisco ASA Series 5500 series 5505 5510 5520 http://ithelpblog.com

SQL exists語法

圖片
Store_Information 表格 Store_Name    Sales Los Angeles    1500 San Diego    250 Los Angeles    300 Boston    700 Geography 表格 Region_Name    Store_Name East    Boston East    New York West    Los Angeles West    San Diego 查詢1 select sum(`sales`) from `store_information` as s where exists(     select * from `geography` as g     where `region_name` = 'West' ) 查詢2 select sum(`sales`) from `store_information` as s where exists(     select * from `geography` as g     where `region_name` = 'West'     and s.`store_name` = g.`store_name` ) 說明 EXISTS 運算子可以連接子查詢,用來判斷子查詢是否有返回的結果,如果有結果返回則為真、否則為假。若 EXISTS 為真,就會繼續執行外查詢中的 SQL;若 EXISTS 為假,則整個 SQL 查詢就不會返回任何結果。 故查詢1返回外查詢的結果 reference http://webdesign.kerthis.com/sql/sql_exists