Just in case this is useful to anyone else who needs a SQL table populated with the 50 U.S. states plus D.C.
insert [State] ([Abbreviation], [Name])
select    'AL', 'Alabama'
union
select    'AK', 'Alaska'
union
select    'AZ', 'Arizona'
union
select    'AR', 'Arkansas'
union
select    'CA', 'California'
union
select    'CO', 'Colorado'
union
select    'CT', 'Connecticut'
union
select    'DE', 'Delaware'
union
select    'DC', 'District of Columbia'
union
select    'FL', 'Florida'
union
select    'GA', 'Georgia'
union
select    'HI', 'Hawaii'
union
select    'ID', 'Idaho'
union
select    'IL', 'Illinois'
union
select    'IN', 'Indiana'
union
select    'IA', 'Iowa'
union
select    'KS', 'Kansas'
union
select    'KY', 'Kentucky'
union
select    'LA', 'Louisiana'
union
select    'ME', 'Maine'
union
select    'MD', 'Maryland'
union
select    'MA', 'Massachusetts'
union
select    'MI', 'Michigan'
union
select    'MN', 'Minnesota'
union
select    'MS', 'Mississippi'
union
select    'MO', 'Missouri'
union
select    'MT', 'Montana'
union
select    'NE', 'Nebraska'
union
select    'NV', 'Nevada'
union
select    'NH', 'New Hampshire'
union
select    'NJ', 'New Jersey'
union
select    'NM', 'New Mexico'
union
select    'NY', 'New York'
union
select    'NC', 'North Carolina'
union
select    'ND', 'North Dakota'
union
select    'OH', 'Ohio'
union
select    'OK', 'Oklahoma'
union
select    'OR', 'Oregon'
union
select    'PA', 'Pennsylvania'
union
select    'RI', 'Rhode Island'
union
select    'SC', 'South Carolina'
union
select    'SD', 'South Dakota'
union
select    'TN', 'Tennessee'
union
select    'TX', 'Texas'
union
select    'UT', 'Utah'
union
select    'VT', 'Vermont'
union
select    'VA', 'Virginia'
union
select    'WA', 'Washington'
union
select    'WV', 'West Virginia'
union
select    'WI', 'Wisconsin'
union
select    'WY', 'Wyoming'