I was having a hard time to find a database with complete set of country list and its corresponding nationalities... Although I found some but probably they are for sale... and you need to buy it (>. So what I've only got (from web surfing / researching) was a text file of country list plus their nationalities. So I don't have any option, so I've created a MS SQL query commands that inserts all 192 countries in a database..by just creating a new script , I mean I coded it into an MS SQL queries that inserts into a table(so you won't need to type it (^.~) ). Here is the instructions : 1) Download or copy the Query / Scripts I provided. INSERT INTO COUNTRY([NAME] , NATIONALITY ) values('Afghanistan', 'Afghan') INSERT INTO COUNTRY([NAME] , NATIONALITY ) values('Albania', 'Albanian') INSERT INTO COUNTRY([NAME] , NATIONALITY ) values('Algeria', 'Algerian') INSERT INTO COUNTRY([NAME] , NATIONALITY ) values('Andorra', ...
It's all about random everyday encounters and experiences...