1-) MSSQL RMOS - declare ile table oluşturma ve o table'i kullanma ulkeler için

BEGIN -- Tablo Tanımlama

Declare @Table Table (Kod Nvarchar(10),Deger Nvarchar(50))

Insert Into @Table (Kod,Deger)

Select 'ABW','ARUBA' Union All

Select 'AFG','AFGANISTAN' Union All

Select 'AGO','ANGOLA' Union All

Select 'AIO','ANGUILLA' Union All

Select 'ALA','ISVEC' Union All

Select 'ALB','ALBANIA' Union All

Select 'AND','ARNAVUTLUK' Union All

Select 'ANT','HOLLANDA-ANT' Union All

Select 'ARE','BIR-ARAP-EMIR' Union All

Select 'ARG','ARJANTIN' Union All

Select 'ARM','ERMENISTAN' Union All

Select 'ASM','AMERIKAN-SAMOASI' Union All

Select 'ATA','ANTARTIKA' Union All

Select 'ATF','G-FRANSA-ANTARTIKA-B' Union All

Select 'ATG','ANTIKUA' Union All

Select 'AUS','AVUSTURALYA' Union All

Select 'AUT','AVUSTURYA' Union All

Select 'AZE','AZERBAYCAN' Union All

Select 'BDI','BURUNDI' Union All

Select 'BEL','BELCIKA' Union All

Select 'BEN','BENIN' Union All

Select 'BFA','BURKINA-FASO' Union All

Select 'BGD','BANGLADES' Union All

Select 'BGR','BULGARISTAN' Union All

Select 'BHR','BAHREYN' Union All

Select 'BHS','BAHAMALAR' Union All

Select 'BIH','BOSNA-HERSEK' Union All

Select 'BLM','SAINT-BARTHELEMY' Union All

Select 'BLR','BEYAZ-RUSYA' Union All

Select 'BLZ','BELIZE' Union All

Select 'BMU','BERMUDA' Union All

Select 'BOL','BOLIVYA' Union All

Select 'BRA','BREZILYA' Union All

Select 'BRB','BARBADOS' Union All

Select 'BRN','BRUNEY' Union All

Select 'BTN','BHUTAN' Union All

Select 'BVT','BOUVET-ADASI' Union All

Select 'BWA','BOTSVANA' Union All

Select 'CAF','ORTA-AFRIKA-CUMHURIY' Union All

Select 'CAN','KANADA' Union All

Select 'CCK','COCOS-ADALARI' Union All

Select 'CHE','ISVICRE' Union All

Select 'CHL','SILI' Union All

Select 'CHN','CIN' Union All

Select 'CIV','COTE-DIVOIRE' Union All

Select 'CMR','KAMERUN' Union All

Select 'COD','DEMOKRATIK-KONGO' Union All

Select 'COG','KONGO-CUMHURIYETI' Union All

Select 'COK','COOK-ADALARI' Union All

Select 'COL','KOLOMBIYA' Union All

Select 'COM','KOMORLAR' Union All

Select 'CPV','YESIL-BURUN-ADALARI' Union All

Select 'CRI','KOSTA-RIKA' Union All

Select 'CUB','KUBA' Union All

Select 'CXR','CHRISTMAS-ADASI' Union All

Select 'CYM','KAYMAN-ADALARI' Union All

Select 'CYP','KIBRIS' Union All

Select 'CZE','CEK-CUMHURIYETI' Union All

Select 'DEU','ALMANYA' Union All

Select 'DEU','ALMANYA' Union All

Select 'U= ','MANYA' Union All

Select 'DJI','CIBUTI' Union All

Select 'DMA','DOMINIKA' Union All

Select 'DNK','DANIMARKA' Union All

Select 'DOM','DOMINIK-CUMHURIYETI' Union All

Select 'DZA','CEZAYIR' Union All

Select 'ECU','EKVATOR' Union All

Select 'EGY','MISIR' Union All

Select 'ERI','ERITRE' Union All

Select 'ESH','BATI-SAHRA' Union All

Select 'ESP','ISPANYA' Union All

Select 'EST','ESTONYA' Union All

Select 'ETH','ETIYOPYA' Union All

Select 'FIN','FINLANDIYA' Union All

Select 'FJI','FIJI' Union All

Select 'FLK','FALKLAND-ADALARI' Union All

Select 'FRA','FRANSA' Union All

Select 'FRO','FAROE-ADALARI' Union All

Select 'FSM','MIKRONEZYA' Union All

Select 'GAB','GABON' Union All

Select 'GBR','BIRLESIK-KRALLIK' Union All

Select 'GEO','GEORGIA' Union All

Select 'GGY','GUERNSEY' Union All

Select 'GHA','GANA' Union All

Select 'GIB','CEBELITARIK' Union All

Select 'GIN','GINE' Union All

Select 'GLP','GUADALUPE' Union All

Select 'GMB','GAMBIYA' Union All

Select 'GNB','GINE-BISSAU' Union All

Select 'GNQ','EKVATOR-GINESI' Union All

Select 'GRC','YUNANISTAN' Union All

Select 'GRD','GRENADA' Union All

Select 'GRL','GRONLAND' Union All

Select 'GTM','GUATEMALA' Union All

Select 'GUF','FRANSIZ-GUYANASI' Union All

Select 'GUM','GUAM' Union All

Select 'GUY','GUYANA' Union All

Select 'HKG','HONG-KONG' Union All

Select 'HMD','HEARD-ISLAND' Union All

Select 'HND','HONDURAS' Union All

Select 'HRV','HIRVATISTAN' Union All

Select 'HTI','HAITI' Union All

Select 'HUN','MACARISTAN' Union All

Select 'IDN','ENDONESIA' Union All

Select 'IMN','MAN ADASI' Union All

Select 'IND','HINDISTAN' Union All

Select 'IOT','INDIAN-OCEAN-TERRITO' Union All

Select 'IRL','IRLANDA' Union All

Select 'IRN','IRAN' Union All

Select 'IRQ','IRAK' Union All

Select 'ISL','IZLANDA' Union All

Select 'ISR','ISRAIL' Union All

Select 'ITA','ITALYA' Union All

Select 'JAM','JAMAIKA' Union All

Select 'JEY','JERSEY' Union All

Select 'JOR','URDUN' Union All

Select 'JPN','JAPONYA' Union All

Select 'KAZ','KAZAKISTAN' Union All

Select 'KEN','KENYA' Union All

Select 'KGZ','KIRGIZISTAN' Union All

Select 'KHM','KAMBOCYA' Union All

Select 'KIR','KIRIBATI' Union All

Select 'KNA','SAINT-KITTS-NEVIS' Union All

Select 'KOR','KORE' Union All

Select 'KWT','KUVEYT' Union All

Select 'LAO','LAO' Union All

Select 'LBN','LUBNAN' Union All

Select 'LBR','LIBERYA' Union All

Select 'LBY','LIBYAN' Union All

Select 'LCA','SAINT-LUCIA' Union All

Select 'LIE','LIHTENSTAYN' Union All

Select 'LKA','SRI-LANKA' Union All

Select 'LSO','LESOTO' Union All

Select 'LTU','LITVANYA' Union All

Select 'LUX','LUKSEMBURG' Union All

Select 'LVA','LETONYA' Union All

Select 'MAC','MAKAO' Union All

Select 'MAF','SAINT-MARTIN' Union All

Select 'MAR','FAS' Union All

Select 'MCO','MONAKO' Union All

Select 'MDA','MOLDOVA' Union All

Select 'MDG','MADAGASKAR' Union All

Select 'MDV','MALDIVLER' Union All

Select 'MEX','MEKSIKA' Union All

Select 'MHL','MARSHALL-ADALARI' Union All

Select 'MKD','MAKEDONYA' Union All

Select 'MLI','MALI' Union All

Select 'MLT','MALTA' Union All

Select 'MMR','MYANMAR' Union All

Select 'MNE','KARADAG' Union All

Select 'MNG','MOGOLISTAN' Union All

Select 'MNP','NORTHERN-MARIANA-ISL' Union All

Select 'MOZ','MOZAMBIK' Union All

Select 'MRT','MORITANYA' Union All

Select 'MSR','MONTSERRAT' Union All

Select 'MTQ','MARTINIQUE' Union All

Select 'MUS','MAURITIUS' Union All

Select 'MWI','MALAVI' Union All

Select 'MYS','MALESYA' Union All

Select 'MYT','MAYOTTE' Union All

Select 'NAM','NAMIBYA' Union All

Select 'NCL','YENI-KALEDONYA' Union All

Select 'NER','NIJER' Union All

Select 'NFK','NORFOLK-ADASI' Union All

Select 'NGA','NIJERYA' Union All

Select 'NIC','NIKARAGUA' Union All

Select 'NIU','NIUE' Union All

Select 'NLD','HOLLANDA' Union All

Select 'NOR','NORVEC' Union All

Select 'NPL','NEPAL' Union All

Select 'NRU','NAURU' Union All

Select 'NZL','YENI-ZELENDA' Union All

Select 'OMN','UMMAN' Union All

Select 'PAK','PAKISTAN' Union All

Select 'PAN','PANAMA' Union All

Select 'PCN','PITCAIRN-ADALARI' Union All

Select 'PER','PERU' Union All

Select 'PHL','FILIPINLER' Union All

Select 'PLW','PALAU' Union All

Select 'PNG','PAPUA-YENI-GINE' Union All

Select 'POL','POLONYA' Union All

Select 'PRI','PORTO-RIKO' Union All

Select 'PRK','KUZEY-KORE' Union All

Select 'PRT','PORTEKIZ' Union All

Select 'PRY','PARAGUAY' Union All

Select 'PSE','PALESTINIAN-TERRITOR' Union All

Select 'PYF','FRANSIZ-POLINEZYASI' Union All

Select 'QAT','KATAR' Union All

Select 'REU','REUNION' Union All

Select 'ROU','ROMANYA' Union All

Select 'RUS','RUSYA' Union All

Select 'RWA','RUANDA' Union All

Select 'SAU','SUUDI-ARABISTAN' Union All

Select 'SDN','SUDAN' Union All

Select 'SEN','SENEGAL' Union All

Select 'SGP','SINGAPUR' Union All

Select 'SGS','GUNEY-GEORGIA' Union All

Select 'SHN','SAINT-HELENA' Union All

Select 'SJM','SVALBARD-AND-MAYEN' Union All

Select 'SLB','SOLOMON-ADALARI' Union All

Select 'SLE','SIERRA-LEONE' Union All

Select 'SLV','EL-SALVADOR' Union All

Select 'SMR','SAN-MARINO' Union All

Select 'SOM','SOMALI' Union All

Select 'SPM','SAINT-PIERRE' Union All

Select 'SRB','SIRBISTAN' Union All

Select 'STP','SAO-TOME-PRINCIPE' Union All

Select 'SUR','SURINAM' Union All

Select 'SVK','SLOVAKYA' Union All

Select 'SVN','SLOVENYA' Union All

Select 'SWE','ISVEC' Union All

Select 'SWZ','SWAZILAND' Union All

Select 'SYC','SEYSELLER' Union All

Select 'SYR','SURIYE' Union All

Select 'TCA','TURKS-CAICOS' Union All

Select 'TCD','CAD' Union All

Select 'TGO','TOGO' Union All

Select 'THA','TAYLAND' Union All

Select 'TJK','TACIKISTAN' Union All

Select 'TKL','TOKELAU' Union All

Select 'TKM','TURKMENISTAN' Union All

Select 'TLS','TIMOR-LESTE' Union All

Select 'TON','TONGA' Union All

Select 'TTO','TRINIDAD-TOBAGO' Union All

Select 'TUN','TUNUS' Union All

Select 'TUR','TURKIYE' Union All

Select 'TUV','TUVALU' Union All

Select 'TWN','TAIWAN-PROVINCE-CHIN' Union All

Select 'TZA','TANZANYA' Union All

Select 'UGA','UGANDA' Union All

Select 'UKR','UKRAYNA' Union All

Select 'UMI','MINOR-OUTLYING' Union All

Select 'URY','URUGAY' Union All

Select 'USA','AMERIKA' Union All

Select 'UZB','OZBEKISTAN' Union All

Select 'VAT','HOLY-SEE' Union All

Select 'VCT','SAINT-VINCENT' Union All

Select 'VEN','VENEZUELA' Union All

Select 'VGB','VIRGIN-ADALARI' Union All

Select 'VIR','VIRGIN-ISLANDS' Union All

Select 'VNM','VIETNAM' Union All

Select 'VUT','VANUATU' Union All

Select 'WLF','WALLIS-FUTUNA' Union All

Select 'WSM','SAMOA' Union All

Select 'YEM','YEMEN' Union All

Select 'ZAF','GUNEY-AFRIKA' Union All

Select 'ZMB','ZAMBIYA' Union All

Select 'ZWE','ZIMBABVE'

END

select * from @Table