SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 list of countries and nationalities
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

skater1976
Starting Member

2 Posts

Posted - 03/19/2006 :  09:29:20  Show Profile
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 nationalities
like 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
Flowing Fount of Yak Knowledge

Sri Lanka
1378 Posts

Posted - 03/19/2006 :  10:15:55  Show Profile
skater1976,

This is a SQL server forum and ur question has no relationship to this forum

However
U 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)
Go to Top of Page

Arnold Fribble
Yak-finder General

United Kingdom
1961 Posts

Posted - 03/19/2006 :  11:37:58  Show Profile
But in case you were wondering, Ur was in what's now Iraq.
Go to Top of Page

skater1976
Starting Member

2 Posts

Posted - 03/19/2006 :  11:43:30  Show Profile
all right thank you very much
Go to Top of Page

Arnold Fribble
Yak-finder General

United Kingdom
1961 Posts

Posted - 03/19/2006 :  11:49:41  Show Profile
For countries, I'd probably start somewhere like this:

http://en.wikipedia.org/wiki/ISO_3166-1

Although 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.

Edited by - Arnold Fribble on 03/19/2006 12:21:12
Go to Top of Page

Srinika
Flowing Fount of Yak Knowledge

Sri Lanka
1378 Posts

Posted - 03/19/2006 :  12:25:06  Show Profile
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

Go to Top of Page

Arnold Fribble
Yak-finder General

United Kingdom
1961 Posts

Posted - 03/19/2006 :  12:36:54  Show Profile
Oh, go to Hell! (which is definitely in Norway)
Go to Top of Page

Srinika
Flowing Fount of Yak Knowledge

Sri Lanka
1378 Posts

Posted - 03/19/2006 :  12:43:06  Show Profile
Same to u
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 03/19/2006 :  16:47:52  Show Profile
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000