CREATE TABLE [dbo].[UsStates](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[State] [varchar](250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Abbreviation] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 CONSTRAINT [PK_UsStates] 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]


INSERT INTO UsStates (state,abbreviation) VALUES ('Alaska', 'AK')
INSERT INTO UsStates (state,abbreviation) VALUES ('Arizona', 'AZ')
INSERT INTO UsStates (state,abbreviation) VALUES ('Arkansas', 'AR')
INSERT INTO UsStates (state,abbreviation) VALUES ('California', 'CA')
INSERT INTO UsStates (state,abbreviation) VALUES ('Colorado', 'CO')
INSERT INTO UsStates (state,abbreviation) VALUES ('Connecticut', 'CT')
INSERT INTO UsStates (state,abbreviation) VALUES ('Delaware', 'DE')
INSERT INTO UsStates (state,abbreviation) VALUES ('District of Columbia', 'DC')
INSERT INTO UsStates (state,abbreviation) VALUES ('Florida', 'FL')
INSERT INTO UsStates (state,abbreviation) VALUES ('Georgia', 'GA')
INSERT INTO UsStates (state,abbreviation) VALUES ('Hawaii', 'HI')
INSERT INTO UsStates (state,abbreviation) VALUES ('Idaho', 'ID')
INSERT INTO UsStates (state,abbreviation) VALUES ('Illinois', 'IL')
INSERT INTO UsStates (state,abbreviation) VALUES ('Indiana', 'IN')
INSERT INTO UsStates (state,abbreviation) VALUES ('Iowa', 'IA')
INSERT INTO UsStates (state,abbreviation) VALUES ('Kansas', 'KS')
INSERT INTO UsStates (state,abbreviation) VALUES ('Kentucky', 'KY')
INSERT INTO UsStates (state,abbreviation) VALUES ('Louisiana', 'LA')
INSERT INTO UsStates (state,abbreviation) VALUES ('Maine', 'ME')
INSERT INTO UsStates (state,abbreviation) VALUES ('Maryland', 'MD')
INSERT INTO UsStates (state,abbreviation) VALUES ('Massachusetts', 'MA')
INSERT INTO UsStates (state,abbreviation) VALUES ('Michigan', 'MI')
INSERT INTO UsStates (state,abbreviation) VALUES ('Minnesota', 'MN')
INSERT INTO UsStates (state,abbreviation) VALUES ('Mississippi', 'MS')
INSERT INTO UsStates (state,abbreviation) VALUES ('Missouri', 'MO')
INSERT INTO UsStates (state,abbreviation) VALUES ('Montana', 'MT')
INSERT INTO UsStates (state,abbreviation) VALUES ('Nebraska', 'NE')
INSERT INTO UsStates (state,abbreviation) VALUES ('Nevada', 'NV')
INSERT INTO UsStates (state,abbreviation) VALUES ('New Hampshire', 'NH')
INSERT INTO UsStates (state,abbreviation) VALUES ('New Jersey', 'NJ')
INSERT INTO UsStates (state,abbreviation) VALUES ('New Mexico', 'NM')
INSERT INTO UsStates (state,abbreviation) VALUES ('New York', 'NY')
INSERT INTO UsStates (state,abbreviation) VALUES ('North Carolina', 'NC')
INSERT INTO UsStates (state,abbreviation) VALUES ('North Dakota', 'ND')
INSERT INTO UsStates (state,abbreviation) VALUES ('Ohio', 'OH')
INSERT INTO UsStates (state,abbreviation) VALUES ('Oklahoma', 'OK')
INSERT INTO UsStates (state,abbreviation) VALUES ('Oregon', 'OR')
INSERT INTO UsStates (state,abbreviation) VALUES ('Pennsylvania', 'PA')
INSERT INTO UsStates (state,abbreviation) VALUES ('Rhode Island', 'RI')
INSERT INTO UsStates (state,abbreviation) VALUES ('South Carolina', 'SC')
INSERT INTO UsStates (state,abbreviation) VALUES ('South Dakota', 'SD')
INSERT INTO UsStates (state,abbreviation) VALUES ('Tennessee', 'TN')
INSERT INTO UsStates (state,abbreviation) VALUES ('Texas', 'TX')
INSERT INTO UsStates (state,abbreviation) VALUES ('Utah', 'UT')
INSERT INTO UsStates (state,abbreviation) VALUES ('Vermont', 'VT')
INSERT INTO UsStates (state,abbreviation) VALUES ('Virginia', 'VA')
INSERT INTO UsStates (state,abbreviation) VALUES ('Washington', 'WA')
INSERT INTO UsStates (state,abbreviation) VALUES ('West Virginia', 'WV')
INSERT INTO UsStates (state,abbreviation) VALUES ('Wisconsin', 'WI')
INSERT INTO UsStates (state,abbreviation) VALUES ('Wyoming', 'WY')

SELECT * FROM UsStates