Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
skater1976
Starting Member
2 Posts |
 Posted - 2006-03-19 : 09:29:20
|
| hi everybody,that's my first post and I have a question(of course),is there an official source where I can find the list of countries and nationalitieslike those ones found in a list box on forms? maybe in a format that I can easily port into a database?thanx in advance and ciao |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-03-19 : 10:15:55
|
| skater1976,This is a SQL server forum and ur question has no relationship to this forumHoweverU visit the web sites and from a page which displays that data, copy & paste to ur file (Excel or Access or a text file or some such) |
 |
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2006-03-19 : 11:37:58
|
| But in case you were wondering, Ur was in what's now Iraq. |
|
|
|
skater1976
Starting Member
2 Posts |
Posted - 2006-03-19 : 11:43:30
|
| all right thank you very much |
|
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2006-03-19 : 11:49:41
|
| For countries, I'd probably start somewhere like this:http://en.wikipedia.org/wiki/ISO_3166-1Although whether you'd want to include Åland, American Samoa, Anguilla, Antarctica, Aruba, Bermuda, Bouvet Island, British Indian Ocean Territory, Cayman Islands, Christmas Island, Cocos (Keeling) Islands, Cook Islands, Falkland Islands (Malvinas), Faroe Islands, French Guiana, French Polynesia, French Southern Territories, Gibraltar, Greenland, Guadeloupe, Guam, Heard Island and McDonald Islands, Macao, Martinique, Mayotte, Montserrat, Netherlands Antilles, New Caledonia, Niue, Norfolk Island, Northern Mariana Islands, Pitcairn, Puerto Rico, Réunion, Saint Helena, Saint Pierre and Miquelon, South Georgia and the South Sandwich Islands, Svalbard and Jan Mayen, Tokelau, Turks and Caicos Islands, United States Minor Outlying Islands, Virgin Islands (British and U.S.), Wallis and Futuna and Western Sahara depends on what your list is for.For nationalities, I'd run away, very quickly. |
|
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-03-19 : 12:25:06
|
quote:
Originally posted by Arnold Fribble
But in case you were wondering, Ur was in what's now Iraq.For countries, I'd probably start somewhere like this:
I am wondering, where can I find I'd Probably Ireland |
|
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2006-03-19 : 12:36:54
|
Oh, go to Hell! (which is definitely in Norway)  |
|
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-03-19 : 12:43:06
|
Same to u  |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-03-19 : 16:47:52
|
| I thought Hell was an Island that Richard Branson owned - and enabled him to do marketing along the lines of "If we muck up we'll send you to Hell for free!"Perhaps there are several Hells ...Kristen |
|
|
|
|
|
|
|
|
list of countries and nationalities