Home OFC Tech (blog) SQL Server Country Table

SQL Server Country Table

E-mail Print

The problem:

I needed a (SQL Server) table containing a list of countries to use in addresses, dropdown lists, etc.

 

The Resolution:

I found a few CSV files and so forth online with country data, but none of them were formatted for the "super lazy" developer.  So I'm sharing the script I wound up using in the hopes that it will save a few minutes of someone's time out there.

The script file is here: CountriesTableLoad.sql.txt.  It creates the table schema and loads the data.  All you have to do is drop it into management studio and hit F5.

 

Country Table Result

 

 


blog comments powered by Disqus
Last Updated ( Sunday, 20 May 2012 23:27 )  

ID Card Printing

WorkForce ID cards are custom designed to reflect you unique business, brand or identity. Click to view our product brochure

WorkForceID_Marketing_v1.11

We also have specific offerings tailored to small businesses and individual entrepreneurs.


Certifications

Oracle Partner Logo

MS Partner Logo

Our Partners

The Gravely Group
INCREASE CDC
ECDI - Columbus
DMW Computers

Our Products

Sample imageNeighborhood Shield Drive
WorkForce ID
My Property Tag

Our Services

Application Development
Website Design
Flash Multimedia Design
Ecommerce & Storefronts
Card Printing & Plastics