SQL script to insert world Currency Symbols in Database table

 When we are working with the Report and we need to create and show the currency symbol with amount. For Example    

Here we are creating a table and storing the Currency symbols in the database table.

Table script

CREATE TABLE Currency_Symbol(    id       INTEGER  NOT NULL PRIMARY KEY   ,country  VARCHAR(36) NOT NULL   ,currency VARCHAR(39) NOT NULL   ,code     VARCHAR(3) NOT NULL   ,symbol              NVARCHAR(5) NOT NULL );

Below is the script to insert records in the table.

INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (1,'Afghanistan','Afghan afghani','AFN',N'؋');  INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (2,'Akrotiri and Dhekelia (UK)','European euro','EUR', N'€'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (3,'Aland Islands (Finland)','European euro','EUR', N'€'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (4,'Albania','Albanian lek','ALL',N'Lek'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (5,'Algeria','Algerian dinar','DZD', N'DA'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (6,'American Samoa (USA)','United States dollar','USD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (7,'Andorra','European euro','EUR', N'€'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (8,'Angola','Angolan kwanza','AOA', N'Kz'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (9,'Anguilla (UK)','East Caribbean dollar','XCD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (10,'Antigua and Barbuda','East Caribbean dollar','XCD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (11,'Argentina','Argentine peso','ARS',N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (12,'Armenia','Armenian dram','AMD', N'֏'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (13,'Aruba (Netherlands)','Aruban florin','AWG', N'ƒ'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (14,'Ascension Island (UK)','Saint Helena pound','SHP', N'£'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (15,'Australia','Australian dollar','USD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (16,'Austria','European euro','EUR', N'€'); ; INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (17,'Azerbaijan','Azerbaijan manat','AZN', N'ман'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (18,'Bahamas','Bahamian dollar','BSD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (19,'Bahrain','Bahraini dinar','BHD', N'BD'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (20,'Bangladesh','Bangladeshi taka','BDT', N'৳'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (21,'Barbados','Barbadian dollar','BBD',N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (23,'Belgium','European euro','EUR', N'€'); ; INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (24,'Belize','Belize dollar','BZD',N'BZ$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (25,'Benin','West African CFA franc','XOF',N'CFA'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (26,'Bermuda (UK)','Bermudian dollar','BMD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (28,'Bolivia','Bolivian boliviano','BOB', N'$b'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (29,'Bonaire (Netherlands)','United States dollar','USD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (30,'Bosnia and Herzegovina','Bosnia and Herzegovina convertible mark','BAM',N'KM'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (31,'Botswana','Botswana pula','BWP', N'P'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (32,'Brazil','Brazilian real','BRL', N'R$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (33,'British Indian Ocean Territory (UK)','United States dollar','USD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (34,'British Virgin Islands (UK)','United States dollar','USD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (35,'Brunei','Brunei dollar','BND', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (36,'Bulgaria','Bulgarian lev','BGN',N'лв'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (37,'Burkina Faso','West African CFA franc','XOF',N'CFA'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (38,'Burundi','Burundi franc','BIF', N'FBu'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (39,'Cabo Verde','Cape Verdean escudo','CVE',N'Esc'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (40,'Cambodia','Cambodian riel','KHR', N'៛'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (41,'Cameroon','Central African CFA franc','XAF',N'FCFA'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (42,'Canada','Canadian dollar','CAD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (43,'Caribbean Netherlands (Netherlands)','United States dollar','USD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (44,'Cayman Islands (UK)','Cayman Islands dollar','KYD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (45,'Central African Republic','Central African CFA franc','XAF',N'FCFA'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (46,'Chad','Central African CFA franc','XAF',N'FCFA'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (47,'Chatham Islands (New Zealand)','New Zealand dollar','NZD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (48,'Chile','Chilean peso','CLP', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (49,'China','Chinese Yuan Renminbi','CNY', N'¥'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (50,'Christmas Island (Australia)','Australian dollar','USD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (51,'Cocos (Keeling) Islands (Australia)','Australian dollar','USD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (52,'Colombia','Colombian peso','COP', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (53,'Comoros','Comorian franc','KMF', N'CF'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (54,'Congo, Democratic Republic of the','Congolese franc','CDF',N'CDF'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (55,'Congo, Republic of the','Central African CFA franc','XAF',N'FCFA'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (57,'Costa Rica','Costa Rican colon','CRC', N'₡'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (58,'Cote d''Ivoire','West African CFA franc','XOF',N'CFA'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (59,'Croatia','Croatian kuna','HRK', N'kn'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (60,'Cuba','Cuban peso','CUP', N'₱'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (61,'Curacao (Netherlands)','Netherlands Antillean guilder','ANG', N'ƒ'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (62,'Cyprus','European euro','EUR', N'€'); ; INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (63,'Czechia','Czech koruna','CZK', N'Kč'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (64,'Denmark','Danish krone','DKK', N'kr'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (65,'Djibouti','Djiboutian franc','DJF', N'Fdj'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (66,'Dominica','East Caribbean dollar','XCD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (67,'Dominican Republic','Dominican peso','DOP', N'RD$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (68,'Ecuador','United States dollar','USD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (69,'Egypt','Egyptian pound','EGP', N'£'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (70,'El Salvador','United States dollar','USD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (71,'Equatorial Guinea','Central African CFA franc','XAF',N'FCFA'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (72,'Eritrea','Eritrean nakfa','ERN', N'Nkf'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (73,'Estonia','European euro','EUR', N'€'); ; INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (74,'Eswatini (formerly Swaziland)','Swazi lilangeni','SZL',N'L'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (75,'Ethiopia','Ethiopian birr','ETB', N'Br'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (76,'Falkland Islands (UK)','Falkland Islands pound','FKP', N'£'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (77,'Faroe Islands (Denmark)','Faroese krona','FK',N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (78,'Fiji','Fijian dollar','FJD',N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (79,'Finland','European euro','EUR', N'€'); ; INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (80,'France','European euro','EUR', N'€'); ; INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (81,'French Guiana (France)','European euro','EUR', N'€'); ; INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (82,'French Polynesia (France)','CFP franc','XPF', N'₣'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (83,'Gabon','Central African CFA franc','XAF',N'FCFA'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (84,'Gambia','Gambian dalasi','GMD', N'D'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (85,'Georgia','Georgian lari','GEL', N'ლ'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (86,'Germany','European euro','EUR', N'€'); ; INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (87,'Ghana','Ghanaian cedi','GHS', N'GH₵'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (88,'Gibraltar (UK)','Gibraltar pound','GIP', N'£'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (89,'Greece','European euro','EUR', N'€'); ; INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (90,'Greenland (Denmark)','Danish krone','DKK', N'kr'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (91,'Grenada','East Caribbean dollar','XCD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (92,'Guadeloupe (France)','European euro','EUR', N'€'); ; INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (93,'Guam (USA)','United States dollar','USD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (94,'Guatemala','Guatemalan quetzal','GTQ', N'Q'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (95,'Guernsey (UK)','Guernsey Pound','GGP', N'£'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (96,'Guinea','Guinean franc','GNF', N'FG'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (97,'Guinea-Bissau','West African CFA franc','XOF',N'CFA'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (98,'Guyana','Guyanese dollar','GYD',N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (100,'Honduras','Honduran lempira','HNL', N'L'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (101,'Hong Kong (China)','Hong Kong dollar','HKD',N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (102,'Hungary','Hungarian forint','HUF', N'Ft'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (103,'Iceland','Icelandic krona','ISK', N'kr'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (104,'India','Indian rupee','INR', N'₹'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (105,'Indonesia','Indonesian rupiah','IDR', N'Rp'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (107,'Iran','Iranian rial','IRR', N'﷼'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (108,'Iraq','Iraqi dinar','IQD', N'ع.د'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (109,'Ireland','European euro','EUR', N'€'); ; INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (110,'Isle of Man (UK)','Manx pound','IMP', N'£'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (111,'Israel','Israeli new shekel','ILS', N'₪'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (112,'Italy','European euro','EUR', N'€'); ; INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (113,'Jamaica','Jamaican dollar','JMD', N'J$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (114,'Japan','Japanese yen','JPY', N'¥'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (115,'Jersey (UK)','Jersey pound','JEP', N'£'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (116,'Jordan','Jordanian dinar','JOD', N'د.ا'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (117,'Kazakhstan','Kazakhstani tenge','KZT', N'лв'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (118,'Kenya','Kenyan shilling','KES', N'Ksh'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (119,'Kiribati','Australian dollar','USD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (120,'Kosovo','European euro','EUR', N'€'); ; INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (121,'Kuwait','Kuwaiti dinar','KWD', N'د.ك'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (122,'Kyrgyzstan','Kyrgyzstani som','KGS', N'лв'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (123,'Laos','Lao kip','LAK', N'₭'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (124,'Latvia','European euro','EUR', N'€'); ; INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (125,'Lebanon','Lebanese pound','LBP', N'£'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (127,'Liberia','Liberian dollar','LRD',N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (128,'Libya','Libyan dinar','LYD', N'ل.د'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (129,'Liechtenstein','Swiss franc','CHF',N'CHF'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (130,'Lithuania','European euro','EUR', N'€'); ; INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (131,'Luxembourg','European euro','EUR', N'€'); ; INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (132,'Macau (China)','Macanese pataca','MOP',N'MOP$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (133,'Madagascar','Malagasy ariary','MGA', N'Ar'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (134,'Malawi','Malawian kwacha','MWK', N'MK'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (135,'Malaysia','Malaysian ringgit','MYR',N'RM'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (136,'Maldives','Maldivian rufiyaa','MVR', N'Rf'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (137,'Mali','West African CFA franc','XOF',N'CFA'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (138,'Malta','European euro','EUR', N'€'); ; INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (139,'Marshall Islands','United States dollar','USD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (140,'Martinique (France)','European euro','EUR', N'€'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (142,'Mauritius','Mauritian rupee','MUR', N'₨'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (143,'Mayotte (France)','European euro','EUR', N'€'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (144,'Mexico','Mexican peso','MXN',N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (145,'Micronesia','United States dollar','USD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (146,'Moldova','Moldovan leu','MDL', N'L'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (147,'Monaco','European euro','EUR', N'€'); ; INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (148,'Mongolia','Mongolian tugrik','MNT', N'₮'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (149,'Montenegro','European euro','EUR', N'€'); ; INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (150,'Montserrat (UK)','East Caribbean dollar','XCD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (151,'Morocco','Moroccan dirham','MAD',N'MAD'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (152,'Mozambique','Mozambican metical','MZN', N'MT'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (153,'Myanmar (formerly Burma)','Myanmar kyat','MMK',N'K'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (154,'Namibia','Namibian dollar','NAD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (155,'Nauru','Australian dollar','USD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (156,'Nepal','Nepalese rupee','NPR', N'₨'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (157,'Netherlands','European euro','EUR', N'€'); ; INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (158,'New Caledonia (France)','CFP franc','XPF', N'₣'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (159,'New Zealand','New Zealand dollar','NZD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (160,'Nicaragua','Nicaraguan cordoba','NIO', N'C$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (161,'Niger','West African CFA franc','XOF',N'CFA'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (162,'Nigeria','Nigerian naira','NGN', N'₦'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (163,'Niue (New Zealand)','New Zealand dollar','NZD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (164,'Norfolk Island (Australia)','Australian dollar','USD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (165,'Northern Mariana Islands (USA)','United States dollar','USD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (166,'North Korea','North Korean won','KPW', N'₩'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (167,'North Macedonia (formerly Macedonia)','Macedonian denar','MKD', N'ден'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (168,'Norway','Norwegian krone','NOK', N'kr'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (169,'Oman','Omani rial','OMR', N'﷼'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (170,'Pakistan','Pakistani rupee','PKR', N'₨'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (171,'Palau','United States dollar','USD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (172,'Palestine','Israeli new shekel','ILS', N'₪'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (173,'Panama','United States dollar','USD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (174,'Papua New Guinea','Papua New Guinean kina','PGK',N'K'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (175,'Paraguay','Paraguayan guarani','PYG', N'Gs'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (176,'Peru','Peruvian sol','PEN', N'S/.'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (177,'Philippines','Philippine peso','PHP',N'Php'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (178,'Pitcairn Islands (UK)','New Zealand dollar','NZD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (179,'Poland','Polish zloty','PLN', N'zł'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (180,'Portugal','European euro','EUR', N'€'); ; INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (181,'Puerto Rico (USA)','United States dollar','USD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (182,'Qatar','Qatari riyal','QAR', N'﷼'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (183,'Reunion (France)','European euro','EUR', N'€'); ; INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (184,'Romania','Romanian leu','RON', N'lei'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (185,'Russia','Russian ruble','RUB', N'руб'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (186,'Rwanda','Rwandan franc','RWF', N'R₣'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (187,'Saba (Netherlands)','United States dollar','USD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (188,'Saint Barthelemy (France)','European euro','EUR', N'€'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (189,'Saint Helena (UK)','Saint Helena pound','SHP', N'£'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (190,'Saint Kitts and Nevis','East Caribbean dollar','XCD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (191,'Saint Lucia','East Caribbean dollar','XCD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (192,'Saint Martin (France)','European euro','EUR', N'€'); ; INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (193,'Saint Pierre and Miquelon (France)','European euro','EUR', N'€'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (194,'Saint Vincent and the Grenadines','East Caribbean dollar','XCD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (195,'Samoa','Samoan tala','WST', N'WS$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (196,'San Marino','European euro','EUR', N'€'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (198,'Saudi Arabia','Saudi Arabian riyal','SAR', N'﷼'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (199,'Senegal','West African CFA franc','XOF',N'CFA'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (200,'Serbia','Serbian dinar','RSD', N'Дин.'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (201,'Seychelles','Seychellois rupee','SCR', N'₨'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (202,'Sierra Leone','Sierra Leonean leone','SLL', N'Le'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (203,'Singapore','Singapore dollar','SGD',N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (204,'Sint Eustatius (Netherlands)','United States dollar','USD',N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (205,'Sint Maarten (Netherlands)','Netherlands Antillean guilder','ANG',N'ƒ'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (206,'Slovakia','European euro','EUR', N'€'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (207,'Slovenia','European euro','EUR', N'€'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (208,'Solomon Islands','Solomon Islands dollar','SBD',N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (209,'Somalia','Somali shilling','SOS',N'S'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (210,'South Africa','South African rand','ZAR',N'R'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (211,'South Georgia Island (UK)','Pound sterling','GBP', N'£'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (212,'South Korea','South Korean won','KRW', N'₩'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (213,'South Sudan','South Sudanese pound','SSP', N'£'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (214,'Spain','European euro','EUR', N'€'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (215,'Sri Lanka','Sri Lankan rupee','LKR', N'₨'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (216,'Sudan','Sudanese pound','SDG', N'ج.س'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (217,'Suriname','Surinamese dollar','SRD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (218,'Svalbard and Jan Mayen (Norway)','Norwegian krone','NOK', N'kr'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (219,'Sweden','Swedish krona','SEK', N'kr'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (220,'Switzerland','Swiss franc','CHF',N'CHF'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (221,'Syria','Syrian pound','SYP', N'£'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (222,'Taiwan','New Taiwan dollar','TWD', N'NT$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (223,'Tajikistan','Tajikistani somoni','TJS',N'SM'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (224,'Tanzania','Tanzanian shilling','TZS', N'TSh'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (225,'Thailand','Thai baht','THB', N'฿'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (226,'Timor-Leste','United States dollar','USD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (227,'Togo','West African CFA franc','XOF',N'CFA'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (228,'Tokelau (New Zealand)','New Zealand dollar','NZD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (229,'Tonga','Tongan pa’anga','TOP', N'T$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (230,'Trinidad and Tobago','Trinidad and Tobago dollar','TTD', N'TT$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (231,'Tristan da Cunha (UK)','Pound sterling','GBP', N'£'); ; INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (232,'Tunisia','Tunisian dinar','TND', N'DT'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (233,'Turkey','Turkish lira','TRY', N'₺'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (234,'Turkmenistan','Turkmen manat','TMT',N'T'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (235,'Turks and Caicos Islands (UK)','United States dollar','USD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (236,'Tuvalu','Australian dollar','USD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (237,'Uganda','Ugandan shilling','UGX', N'USh'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (238,'Ukraine','Ukrainian hryvnia','UAH', N'₴'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (239,'United Arab Emirates','UAE dirham','AED', N'د.إ'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (240,'United Kingdom','Pound sterling','GBP', N'£'); ; INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (241,'United States of America','United States dollar','USD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (242,'Uruguay','Uruguayan peso','UYU', N'$U'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (243,'US Virgin Islands (USA)','United States dollar','USD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (244,'Uzbekistan','Uzbekistani som','UZS', N'лв'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (246,'Vatican City (Holy See)','European euro','EUR', N'€'); ; INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (248,'Vietnam','Vietnamese dong','VND', N'₫'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (249,'Wake Island (USA)','United States dollar','USD', N'$'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (250,'Wallis and Futuna (France)','CFP franc','XPF', N'₣'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (251,'Yemen','Yemeni rial','YER', N'﷼'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (252,'Zambia','Zambian kwacha','ZMW', N'ZK'); INSERT INTO Currency_Symbol(id,country,currency,code, symbol) VALUES (253,'Zimbabwe','United States dollar','USD', N'$');

Table looks like.