sarpay
11/25/2013 - 7:19 AM
[sql] states table insert script
[sql] states table insert script
CREATE TABLE [dbo].[States](
[ID] [int] NOT NULL,
[Abbr] [nvarchar](2) NOT NULL,
[Name] [nvarchar](50) NOT NULL,
[Latitude] [nvarchar](50) NOT NULL,
[Longitude] [nvarchar](50) 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 [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(1,'AL','Alabama','32.7990','-86.8073')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(2,'AK','Alaska','61.3850','-152.2683')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(3,'AZ','Arizona','33.7712','-111.3877')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(4,'AR','Arkansas','34.9513','-92.3809')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(5,'CA','California','36.1700','-119.7462')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(6,'CO','Colorado','39.0646','-105.3272')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(7,'CT','Connecticut','41.5834','-72.7622')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(8,'DE','Delaware','39.3498','-75.5148')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(9,'DC','District of Columbia','38.8964','-77.0262')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(10,'FL','Florida','27.8333','-81.7170')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(11,'GA','Georgia','32.9866','-83.6487')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(12,'HI','Hawaii','21.1098','-157.5311')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(13,'ID','Idaho','44.2349','-114.5103')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(14,'IL','Illinois','40.3363','-89.0022')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(15,'IN','Indiana','39.8647','-86.2604')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(16,'IA','Iowa','42.0046','-93.2140')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(17,'KS','Kansas','38.5111','-96.8005')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(18,'KY','Kentucky','37.6690','-84.6514')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(19,'LA','Louisiana','31.1801','-91.8749')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(20,'ME','Maine','44.6074','-69.3977')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(21,'MD','Maryland','39.0724','-76.7902')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(22,'MA','Massachusetts','42.2373','-71.5314')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(23,'MI','Michigan','43.3504','-84.5603')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(24,'MN','Minnesota','45.7326','-93.9196')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(25,'MS','Mississippi','32.7673','-89.6812')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(26,'MO','Missouri','38.4623','-92.3020')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(27,'MT','Montana','46.9048','-110.3261')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(28,'NE','Nebraska','41.1289','-98.2883')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(29,'NV','Nevada','38.4199','-117.1219')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(30,'NH','New Hampshire','43.4108','-71.5653')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(31,'NJ','New Jersey','40.3140','-74.5089')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(32,'NM','New Mexico','34.8375','-106.2371')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(33,'NY','New York','42.1497','-74.9384')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(34,'NC','North Carolina','35.6411','-79.8431')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(35,'ND','North Dakota','47.5362','-99.7930')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(36,'OH','Ohio','40.3736','-82.7755')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(37,'OK','Oklahoma','35.5376','-96.9247')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(38,'OR','Oregon','44.5672','-122.1269')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(39,'PA','Pennsylvania','40.5773','-77.2640')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(40,'RI','Rhode Island','41.6772','-71.5101')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(41,'SC','South Carolina','33.8191','-80.9066')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(42,'SD','South Dakota','44.2853','-99.4632')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(43,'TN','Tennessee','35.7449','-86.7489')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(44,'TX','Texas','31.1060','-97.6475')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(45,'UT','Utah','40.1135','-111.8535')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(46,'VT','Vermont','44.0407','-72.7093')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(47,'VA','Virginia','37.7680','-78.2057')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(48,'WA','Washington','47.3917','-121.5708')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(49,'WV','West Virginia','38.4680','-80.9696')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(50,'WI','Wisconsin','44.2563','-89.6385')
INSERT INTO [States] ([ID],[Abbr],[Name],[Latitude],[Longitude])VALUES(51,'WY','Wyoming','42.7475','-107.2085')