There are many tasks developers do over and over again in many projects. One of these for me has been creating a list of countries for a database table. Using the ISO 3166 English country names and code elements I've created a T-SQL script for public consumption. Just change the use statement to your database name and find and replace the table name to your spec. Hopefully this saves you some time.

countries-tsql