본문 바로가기

ASP,MSSQL Tip

각 나라명 Country name

<select name="M_Ecountry">
        <option value="&nbsp;" >-- Please Select --</option>
        <option value="USA" SELECTED>United States</option>
        <option value="CAN" >Canada</option>
        <option value="UNK" >United Kingdom</option>
        <option value="AFG" >Afghanistan</option>
        <option value="ALB" >Albania</option>
        <option value="ALG" >Algeria</option>
        <option value="AND" >Andorra</option>
        <option value="ANG" >Angola</option>
        <option value="ANI" >Antigua & Barbuda</option>
        <option value="ARG" >Argentina</option>
        <option value="ARM" >Armenia</option>
        <option value="ARU" >Aruba</option>
        <option value="AUS" >Australia</option>
        <option value="AUT" >Austria</option>
        <option value="AZE" >Azerbaijan</option>
        <option value="BHM" >Bahamas</option>
        <option value="BAH" >Bahrain</option>
        <option value="BAN" >Bangladesh</option>
        <option value="BAR" >Barbados</option>
        <option value="BLR" >Belarus</option>
        <option value="BEL" >Belgium</option>
        <option value="BLI" >Belize</option>
        <option value="BEN" >Benin</option>
        <option value="BER" >Bermuda</option>
        <option value="BHU" >Bhutan</option>
        <option value="BOL" >Bolivia</option>
        <option value="BOS" >Bosnia & Herzegovina</option>
        <option value="BOT" >Botswana</option>
        <option value="BRA" >Brazil</option>
        <option value="BVI" >British Virgin Islands</option>
        <option value="BWI" >British West Indies</option>
        <option value="BRU" >Brunei</option>
        <option value="BUL" >Bulgaria</option>
        <option value="BUK" >Burkina Faso</option>
        <option value="BDI" >Burundi</option>
        <option value="CAM" >Cambodia</option>
        <option value="CMR" >Cameroon</option>
        <option value="CPV" >Cape Verde</option>
        <option value="CAY" >Cayman Islands</option>
        <option value="CAR" >Central African Republic</option>
        <option value="CHA" >Chad</option>
        <option value="CHL" >Chile</option>
        <option value="CHI" >China</option>
        <option value="COL" >Colombia</option>
        <option value="COM" >Comoros</option>
        <option value="CON" >Congo (Brazzaville)</option>
        <option value="COK" >Congo (Kinshasa)</option>
        <option value="COS" >Costa Rica</option>
        <option value="CDI" >Cote d'Ivoire</option>
        <option value="CRO" >Croatia</option>
        <option value="CUB" >Cuba</option>
        <option value="CYP" >Cyprus</option>
        <option value="CZE" >Czech Republic</option>
        <option value="DEN" >Denmark</option>
        <option value="DJI" >Djibouti</option>
        <option value="DMI" >Dominica</option>
        <option value="DOM" >Dominican Republic</option>
        <option value="ETM" >East Timor (Timor Timur)</option>
        <option value="ECU" >Ecuador</option>
        <option value="EGY" >Egypt</option>
        <option value="ELS" >El Salvador</option>
        <option value="EQG" >Equatorial Guinea</option>
        <option value="ERI" >Eritrea</option>
        <option value="EST" >Estonia</option>
        <option value="ETH" >Ethiopia</option>
        <option value="FAL" >Falkland Islands</option>
        <option value="FAR" >Faroe Islands</option>
        <option value="FIJ" >Fiji</option>
        <option value="FIN" >Finland</option>
        <option value="FRA" >France</option>
        <option value="GAB" >Gabon</option>
        <option value="GAM" >Gambia</option>
        <option value="GEO" >Georgia</option>
        <option value="GER" >Germany</option>
        <option value="GHA" >Ghana</option>
        <option value="GIB" >Gibraltar</option>
        <option value="GRE" >Greece</option>
        <option value="GRN" >Greenland</option>
        <option value="GRD" >Grenada</option>
        <option value="GUA" >Guatemala</option>
        <option value="GUI" >Guinea</option>
        <option value="GUB" >Guinea-Bissau</option>
        <option value="GUY" >Guyana</option>
        <option value="HAI" >Haiti</option>
        <option value="HON" >Honduras</option>
        <option value="HOK" >HONG KONG</option>
        <option value="HUN" >Hungary</option>
        <option value="ICE" >Iceland</option>
        <option value="INA" >India</option>
        <option value="IND" >Indonesia</option>
        <option value="IRN" >Iran</option>
        <option value="IRQ" >Iraq</option>
        <option value="IRE" >Ireland</option>
        <option value="ISR" >Israel</option>
        <option value="ITA" >Italy</option>
        <option value="JAM" >Jamaica</option>
        <option value="JAP" >Japan</option>
        <option value="JOR" >Jordan</option>
        <option value="KAZ" >Kazakhstan</option>
        <option value="KEN" >Kenya</option>
        <option value="KIR" >Kiribati</option>
        <option value="KOS" >Kosovo</option>
        <option value="KUW" >Kuwait</option>
        <option value="KYR" >Kyrgyzstan</option>
        <option value="LAO" >Laos</option>
        <option value="LAT" >Latvia</option>
        <option value="LEB" >Lebanon</option>
        <option value="LES" >Lesotho</option>
        <option value="LIB" >Liberia</option>
        <option value="LYB" >Libya</option>
        <option value="LIC" >Lichtenstein</option>
        <option value="LIT" >Lithuania</option>
        <option value="LUX" >Luxembourg</option>
        <option value="MOC" >Macau</option>
        <option value="MAC" >Macedonia</option>
        <option value="MAD" >Madagascar</option>
        <option value="MLW" >Malawi</option>
        <option value="MAL" >Malaysia</option>
        <option value="MDV" >Maldives</option>
        <option value="MLI" >Mali</option>
        <option value="MAT" >Malta</option>
        <option value="MHI" >Marshall Islands</option>
        <option value="MAR" >Mauritania</option>
        <option value="MAU" >Mauritius</option>
        <option value="MEX" >Mexico</option>
        <option value="MIC" >Micronesia</option>
        <option value="MOL" >Moldova</option>
        <option value="MNC" >Monaco</option>
        <option value="MON" >Mongolia</option>
        <option value="MTG" >Montenegro</option>
        <option value="MSA" >Montserrat</option>
        <option value="MOR" >Morocco</option>
        <option value="MOZ" >Mozambique</option>
        <option value="MYA" >Myanmar</option>
        <option value="NAM" >Namibia</option>
        <option value="NAU" >Nauru</option>
        <option value="NEP" >Nepal</option>
        <option value="NET" >Netherlands</option>
        <option value="ANT" >Netherlands Antilles</option>
        <option value="NZE" >New Zealand</option>
        <option value="NIC" >Nicaragua</option>
        <option value="NGR" >Niger</option>
        <option value="NIG" >Nigeria</option>
        <option value="NKO" >North Korea</option>
        <option value="NOR" >Norway</option>
        <option value="OMA" >Oman</option>
        <option value="PAK" >Pakistan</option>
        <option value="PAL" >Palau</option>
        <option value="PAN" >Panama</option>
        <option value="PAP" >Papua New Guinea</option>
        <option value="PAR" >Paraguay</option>
        <option value="PER" >Peru</option>
        <option value="PHI" >Philippines</option>
        <option value="POL" >Poland</option>
        <option value="POR" >Portugal</option>
        <option value="QAT" >Qatar</option>
        <option value="ROM" >Romania</option>
        <option value="RUS" >Russia</option>
        <option value="RWA" >Rwanda</option>
        <option value="SAM" >Samoa</option>
        <option value="SAN" >San Marino</option>
        <option value="SAO" >Sao Tome and Principe</option>
        <option value="SAU" >Saudi Arabia</option>
        <option value="SCT" >Scotland</option>
        <option value="SEN" >Senegal</option>
        <option value="SER" >Serbia</option>
        <option value="SEY" >Seychelles</option>
        <option value="SIE" >Sierra Leone</option>
        <option value="SNG" >Singapore</option>
        <option value="SLO" >Slovakia</option>
        <option value="SLV" >Slovenia</option>
        <option value="SOL" >Solomon Islands</option>
        <option value="SOM" >Somalia</option>
        <option value="SFR" >South Africa</option>
        <option value="SKO" >South Korea</option>
        <option value="SPN" >Spain</option>
        <option value="SRI" >Sri Lanka</option>
        <option value="SKN" >St Kitts & Nevis</option>
        <option value="STL" >St Lucia</option>
        <option value="STM" >St Martin</option>
        <option value="STV" >St Vincent</option>
        <option value="SUD" >Sudan</option>
        <option value="SUR" >Suriname</option>
        <option value="SWA" >Swaziland</option>
        <option value="SWE" >Sweden</option>
        <option value="SWI" >Switzerland</option>
        <option value="SYR" >Syria</option>
        <option value="TAI" >Taiwan</option>
        <option value="TAJ" >Tajikistan</option>
        <option value="TAN" >Tanzania</option>
        <option value="THA" >Thailand</option>
        <option value="TOG" >Togo</option>
        <option value="TON" >Tonga</option>
        <option value="TRI" >Trinidad & Tobago</option>
        <option value="TUN" >Tunisia</option>
        <option value="TUR" >Turkey</option>
        <option value="TUK" >Turkmenistan</option>
        <option value="TKC" >Turks & Caicos Islands</option>
        <option value="TUV" >Tuvalu</option>
        <option value="UGA" >Uganda</option>
        <option value="UKR" >Ukraine</option>
        <option value="UAR" >United Arab Emirates</option>
        <option value="URU" >Uruguay</option>
        <option value="UZB" >Uzbekistan</option>
        <option value="VAN" >Vanuatu</option>
        <option value="VAT" >Vatican City</option>
        <option value="VEN" >Venezuela</option>
        <option value="VIE" >Vietnam</option>
        <option value="WSA" >Western Sahara</option>
        <option value="YEM" >Yemen</option>
        <option value="ZAM" >Zambia</option>
        <option value="ZIM" >Zimbabwe</option>
       </SELECT>

'ASP,MSSQL Tip' 카테고리의 다른 글

SELECT 문을 이용한 데이터 UPDATE  (0) 2014.03.10
[asp] ABCUpload UTF-8  (0) 2014.02.28
[ASP Request.Form 배열로 받기  (0) 2013.11.29
[MS-SQL] sp_change_users_login  (0) 2013.08.06
[html5] html5에서 중단된 태그들  (0) 2013.08.02