Saturday, December 31, 2016

SQL Script for Insert the Currency and that Symbol in Database .


INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('United Arab Emirates','United Arab Emirates dirham', 'AED', 'AED');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Armenian dram','Armenian dram', 'AMD', N'֏');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Angolan kwanza','Angolan kwanza', 'AOA', 'Kz');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Bangladeshi taka','Bangladeshi taka', 'BDT', N'৳');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Bahraini dinar','Bahraini dinar', 'BDT', N'.د.ب');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Burundian franc','Burundian franc', 'BIF', 'BIF');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Bitcoin','Bitcoin', 'BTC', '฿');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Bhutanese ngultrum','Bhutanese ngultrum', 'BTN', 'BTN');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Belarusian ruble','Belarusian ruble', 'BYN', 'BYN');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Congolese franc','Congolese franc', 'CDF', 'FC');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Chilean Unit of Account','Chilean Unit of Account', 'CLF', 'UF');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Cape Verdean escudo','Cape Verdean escudo', 'CVE', 'CVE');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Deutsche Mark','Deutsche Mark', 'DEM', 'DEM');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Djiboutian franc','Djiboutian franc', 'DJF', 'Fdj');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Algerian dinar','Algerian dinar', 'DZD', 'DZD');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Eritrean nakfa','Eritrean nakfa', 'ERN', 'ERN');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Ethiopian birr','Ethiopian birr', 'ETB', 'Br');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('French franc','French franc', 'FRF', 'Fr');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Georgian lari','Georgian lari', 'GEL', '₾');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Ghanaian cedi','Ghanaian cedi', 'GHS', '¢');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Haitian gourde','Haitian gourde', 'HTG', 'G');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Irish Pound','Irish Pound', 'IEP', '£');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Iraqi Dinar','Iraqi Dinar', 'IQD', 'IQD');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Italian Lira','Italian Lira', 'ITL', '£');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Jordanian Dinar','IJordanian Dinar', 'JOD', 'JOD');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Kenyan Shilling','Kenyan Shilling', 'KES', 'KES');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Comorian Franc','Comorian Franc', 'KMS', 'KMF');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Kuwaiti Dinar','Kuwaiti Dinar', 'KWD', 'KD');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Lesotho Loti','Lesotho Loti', 'LSL', 'L');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Libyan Dinar','Libyan Dinar', 'LYD', 'LD');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Moroccan Dirham','Moroccan Dirham', 'MAD', 'MAD');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Moldovan Leu','Moldovan Leu', 'MDL', 'MDL');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Malagasy Ariary','Malagasy Ariary', 'MGA', 'MGS');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Myanmar Kyat','Myanmar Kyat', 'MMK', 'K');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Macanese Pataca','Macanese Pataca', 'MOP', 'MOP$');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Mauritanian Ouguiya ','Mauritanian Ouguiya ', 'MRO', 'UM');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Maldivian Rufiyaa ','Maldivian Rufiyaa ', 'MVR', 'MVR');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Malawian Kwacha ','Malawian Kwacha ', 'MWK', 'MWK');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Papua New Guinean Kina','Papua New Guinean Kina ', 'PGK', 'K');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Rwandan Franc','Rwandan Franc ', 'RWF', 'RF');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Sudanese Pound ','Sudanese Pound  ', 'SDG', 'SDG');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Slovak Koruna ','Slovak Koruna  ', 'SKK', 'Kcs');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Sierra Leonean Leone ','Sierra Leonean Leone  ', 'SLL', 'Le');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Príncipe Dobra ','Príncipe Dobra   ', 'STD', 'STD');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Swazi Lilangeni ','Swazi Lilangeni  ', 'SZL', 'SZL');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Tajikistani Somoni ','Tajikistani Somoni ', 'TJS', 'TJS');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Turkmenistani Manat ','Turkmenistani Manat', 'TMT', 'T');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Tunisian Dinar','Tunisian Dinar', 'TND', 'DT');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Tongan Paʻanga','Tongan Paʻanga', 'TOP', 'T$');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Tanzanian Shilling','Tanzanian Shilling', 'TZS', 'TSh');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Ugandan Shilling','Ugandan Shilling', 'UGX', 'USh');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Vanuatu Vatu','Vanuatu Vatu', 'VUV', 'VT');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Samoan Tala','Samoan Tala', 'WST', ' WS$ ');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Central African CFA Franc','Central African CFA Franc', 'FCFA', 'FCFA ');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('West African CFA Franc','West African CFA Franc', 'CFA', 'CFA ');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('CFP Franc','CFP Franc', 'CFPF', 'CFPF ');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Zambian Kwacha','Zambian Kwacha', 'ZMK', 'ZMK ');
INSERT INTO Currencies (country, currency, code,symbol,price) VALUES ('Zambian Kwacha','Zambian Kwacha', 'ZMW', 'ZMW ');








No comments:

Post a Comment

Featured Post

What is JavaScript? What is the role of JavaScript engine?

  The JavaScript is a Programming language that is used for converting static web pages to interactive and dynamic web pages. A JavaScript e...