T-SQL Look-up Table of States and Abbreviations

Creates a table named States and inserts all U.S. states and abbreviations.

 

USE [adminDB]

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[States](

    [ID] [int] IDENTITY(1,1) NOT NULL,

    [state] [nchar](250) NOT NULL,

    [state_abbr] [nchar](5) NOT NULL,

 CONSTRAINT [PK_States] PRIMARY KEY CLUSTERED 

(

    [ID] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'Alabama', N'AL')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'Alaska', N'AK')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'Arizona', N'AZ')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'Arkansas', N'AR')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'California', N'CA')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'Colorado', N'CO')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'Connecticut', N'CT')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'Delaware', N'DE')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'District of Columbia', N'DC')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'Florida', N'FL')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'Georgia', N'GA')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'Hawaii', N'HI')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'Idaho', N'ID')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'Illinois', N'IL')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'Indiana', N'IN')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'Iowa', N'IA')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'Kansas', N'KS')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'Kentucky', N'KY')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'Louisiana', N'LA')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'Maine', N'ME')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'Maryland', N'MD')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'Massachusetts', N'MA')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'Michigan', N'MI')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'Minnesota', N'MN')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'Mississippi', N'MS')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'Missouri', N'MO')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'Montana', N'MT')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'Nebraska', N'NE')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'Nevada', N'NV')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'New Hampshire', N'NH')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'New Jersey', N'NJ')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'New Mexico', N'NM')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'New York', N'NY')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'North Carolina', N'NC')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'North Dakota', N'ND')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'Ohio', N'OH')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'Oklahoma', N'OK')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'Oregon', N'OR')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'Pennsylvania', N'PA')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'Rhode Island', N'RI')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'South Carolina', N'SC')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'South Dakota', N'SD')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'Tennessee', N'TN')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'Texas', N'TX')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'Utah', N'UT')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'Vermont', N'VT')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'Virginia', N'VA')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'Washington', N'WA')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'West Virginia', N'WV')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'Wisconsin', N'WI')

INSERT INTO [adminDB].[dbo].[States]([state],[state_abbr]) VALUES (N'Wyoming', N'WY')

GO