loads of useful information, examples and tutorials pertaining to web development utilizing asp.net, c#, vb, css, xhtml, javascript, sql, xml, ajax and everything else...

 



Advertise Here
C-Sharpener.com - Programming is Easy!  Learn Asp.Net & C# in just days, Guaranteed!

SQL State and Country lists

by naspinski 1/11/2009 6:33:00 AM

sql files to make and fill country and state lists with abbreviations

Doesn't get any more straight-forward than that, here is the table structures:
CREATE TABLE dbo.country (
country_id INT NOT NULL PRIMARY KEY IDENTITY,
country_name VARCHAR(50) NOT NULL,
country_abbrev VARCHAR(3) NOT NULL
);

CREATE TABLE dbo.state (
state_id INT NOT NULL PRIMARY KEY IDENTITY,
state_name VARCHAR(50) NOT NULL,
state_abbrev VARCHAR(2) NOT NULL
);



Related posts

Comments

12/31/2010 2:42:06 AM

pingback
Pingback from forum.codecall.net

MYSQL : Country + State list .sql

forum.codecall.net


Comments are closed