Useful SQL Script to generate Countries & US States

I'm currently working on a project where I need to quickly insert a list of Countries and Us States into a database table. This is not the first time that I've needed to have a useful script handy for this sort of thing. I had a quick look around the net and couldn't find exactly what I needed. So, I've put together two scripts, one to create a table of US States and one to create a table of Countries.


Download the two scripts:

Countries - here
US States - here

If you've got any useful SQL scripts like this please let me know and I'll add it to this list.