States dump

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[State](
    [Id] [char](2) NOT NULL,
    [Name] [varchar](50) NOT NULL,
 CONSTRAINT [PK_State_1] 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
SET ANSI_PADDING OFF
GO
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'AK', N'Alaska')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'AL', N'Alabama')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'AR', N'Arkansas')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'AZ', N'Arizona')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'CA', N'California')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'CO', N'Colorado')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'CT', N'Connecticut')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'DC', N'District of Columbia')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'DE', N'Delaware')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'FL', N'Florida')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'GA', N'Georgia')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'HI', N'Hawaii')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'IA', N'Iowa')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'ID', N'Idaho')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'IL', N'Illinois')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'IN', N'Indiana')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'KS', N'Kansas')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'KY', N'Kentucky')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'LA', N'Louisiana')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'MA', N'Massachusetts')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'MD', N'Maryland')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'ME', N'Maine')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'MI', N'Michigan')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'MN', N'Minnesota')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'MO', N'Missouri')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'MS', N'Mississippi')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'MT', N'Montana')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'NC', N'North Carolina')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'ND', N'North Dakota')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'NE', N'Nebraska')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'NH', N'New Hampshire')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'NJ', N'New Jersey')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'NM', N'New Mexico')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'NV', N'Nevada')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'NY', N'New York')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'OH', N'Ohio')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'OK', N'Oklahoma')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'OR', N'Oregon')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'PA', N'Pennsylvania')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'PR', N'Puerto Rico')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'RI', N'Rhode Island')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'SC', N'South Carolina')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'SD', N'South Dakota')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'TN', N'Tennessee')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'TX', N'Texas')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'UT', N'Utah')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'VA', N'Virginia')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'VI', N'Virgin Islands, U.S.')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'VT', N'Vermont')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'WA', N'Washington')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'WI', N'Wisconsin')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'WV', N'West Virginia')
INSERT [dbo].[State] ([Id], [Name]) VALUES (N'WY', N'Wyoming')