Skip to content

Country Name and ISO 3166 SQL Server Import File

Howdy,

Today I found myself in need for a country list (specifically ISO 3166 for completeness) and like many others it wouldn’t be the first time I’ve needed to install one of these in a database. So off I headed to google in search for a ISO country list sql server (.sql) import file.

Found a stack of information but not many with the robustness as Wm. Rhodes version over at 27.org. He had a great list and all the columns I preferred, but it was written for MySQL.

Not to matter, I have made a SQL Server port and here it is below. Massive Respect! to Wm. Rhodes @ 27.org!

http://goneale.com/files/code/Iso3166CountryList.sql

VN:F [1.9.10_1130]
Rating: 5.0/5 (3 votes cast)
VN:F [1.9.10_1130]
Rating: 0 (from 0 votes)
Country Name and ISO 3166 SQL Server Import File, 5.0 out of 5 based on 3 ratings
Bookmark and Share
kick it on DotNetKicks.com
Shout it

NOW, FOR A WORD FROM OUR SPONSORS
Post a comment — Trackback URI RSS 2.0 feed for these comments This entry (permalink) was posted on Thursday, January 22, 2009, at 3:23 pm by Graham O'Neale. Filed in Database and tagged , .

2 Comments

  1. Nilanka

    Thanks! This is cool :mrgreen:

    VA:F [1.9.10_1130]
    Rating: 0.0/5 (0 votes cast)
    VA:F [1.9.10_1130]
    Rating: 0 (from 0 votes)
    Posted on 03-Feb-11 at 2:52 am | Permalink
  2. Business Websites

    Very useful! :grin:

    I’ve modified some of the fields to suit including adding a SortOrder column which allows clients to place regular countries at the top if they wish. :idea:

    Thanks again.

    VA:F [1.9.10_1130]
    Rating: 0.0/5 (0 votes cast)
    VA:F [1.9.10_1130]
    Rating: 0 (from 0 votes)
    Posted on 29-Aug-11 at 6:22 pm | Permalink

Post a Comment

Your email is never published nor shared. Required fields are marked *
*
*

My name is Graham O'Neale and I'm a software architect from Gold Coast, Australia. I am an overtime thinker, full time coder and awake part time in the real world. I have a keen interest in software development, particularly in the realm of programming (C#, ASP.NET, ASP.NET MVC, LINQ (2 SQL), Entity Framework, Silverlight, Blend, WCF, WPF) and a keen interest in the cutting edge and innovation. I have a new found love for design patterns, ALT.NET practices and well crafted software architecture. The purpose of this blog is to express any thoughts, findings, tips and gripes along my travels in the wonderful world of coding and technology...