Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 CandianProvinceCities Create Insert Script

Author  Topic 

lookmemuthu
Starting Member

3 Posts
Posted - 2010-11-04 : 08:32:55
Is any Insert script for Province/Cities for Cananda?

Muthu T

lookmemuthu
Starting Member

3 Posts
Posted - 2010-11-04 : 08:37:47
-- Create Script for Countries table

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Countries]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Countries](
[CountryID] [int] NOT NULL,
[CountryName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
CONSTRAINT [PK_Countries] PRIMARY KEY CLUSTERED
(
[CountryID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

END
GO

-- Create Script for States table

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[States]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[States](
[StateCode] [nchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CountryID] [int] NOT NULL,
[StateName] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
CONSTRAINT [PK_States] PRIMARY KEY CLUSTERED
(
[StateCode] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO

-- Create Script for Cities table

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Cities]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Cities](
[CityID] [int] NOT NULL,
[StateCode] [nchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CityName] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
END
GO

-- Binding relationship between States & Cities with StateCode

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Cities_States]') AND parent_object_id = OBJECT_ID(N'[dbo].[Cities]'))
ALTER TABLE [dbo].[Cities] WITH CHECK ADD CONSTRAINT [FK_Cities_States] FOREIGN KEY([StateCode])
REFERENCES [dbo].[States] ([StateCode])

-- Binding relationship between Contries & States CountryID

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_States_Countries]') AND parent_object_id = OBJECT_ID(N'[dbo].[States]'))
ALTER TABLE [dbo].[States] WITH CHECK ADD CONSTRAINT [FK_States_Countries] FOREIGN KEY([CountryID])
REFERENCES [dbo].[Countries] ([CountryID])


-- Insert Script for Countries table

INSERT INTO [Countries] ([CountryID],[CountryName])VALUES(1,'CANADA')
INSERT INTO [Countries] ([CountryID],[CountryName])VALUES(2,'UNITED STATES')

-- Insert SCript for States table

INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('AA',2,'Armed Forces America')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('AB',1,'Alberta')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('AE',2,'Armed Forces Africa')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('AK',2,'Alaska')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('AL',2,'Alabama')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('AP',2,'Armed Forces Pacific')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('AR',2,'Arkansas')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('AS',2,'American Somoa')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('AZ',2,'Arizona')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('BC',1,'British Columbia')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('CA',2,'California')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('CO',2,'Colorado')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('CT',2,'Connecticut')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('DC',2,'District of Columbia')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('DE',2,'Delaware')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('FL',2,'Florida')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('FM',2,'Federated States of Micronesia')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('GA',2,'Georgia')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('GU',2,'Guam')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('HI',2,'Hawaii')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('IA',2,'Iowa')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('ID',2,'Idaho')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('IL',2,'Illinois')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('IN',2,'Indiana')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('KS',2,'Kansas')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('KY',2,'Kentucky')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('LA',2,'Louisiana')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('MA',2,'Massachusetts')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('MB',1,'Manitoba')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('MD',2,'Maryland')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('ME',2,'Maine')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('MH',2,'Marshall Islands')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('MI',2,'Michigan')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('MN',2,'Minnesota')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('MO',2,'Missouri')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('MP',2,'Northern Mariana Irelands')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('MS',2,'Mississippi')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('MT',2,'Montana')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('NB',1,'New Brunswick')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('NC',2,'North Carolina')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('ND',2,'North Dakota')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('NE',2,'Nebraska')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('NF',1,'New Foundland')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('NH',2,'New Hampshire')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('NJ',2,'New Jersy')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('NM',2,'New Mexico')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('NS',1,'Nova Scotia')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('NT',1,'Northwest Territories')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('NV',2,'Nevada')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('NY',2,'New York')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('Oh',2,'Ohio')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('OK',2,'Oklahoma')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('ON',1,'Ontario')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('OR',2,'Oregon')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('PA',2,'Pennsylvania')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('PE',1,'Prince Edward Island')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('PM',2,'Palau')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('PQ',1,'Quebec')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('PR',2,'Puerto Rico')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('RI',2,'Rhode Island')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('SC',2,'South Carolina')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('SD',2,'South Dakota')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('SK',1,'Saskatchewan')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('TN',2,'Tennessee')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('TX',2,'Texas')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('UT',2,'Utah')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('VA',2,'Virginia')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('VI',2,'U.S Virgin Islands')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('VT',2,'Vermont')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('WA',2,'Washington')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('WI',2,'Wisconsin')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('WV',2,'West Virginia')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('WY',2,'Wyoming')
INSERT INTO [States] ([StateCode],[CountryID],[StateName])VALUES('YT',1,'Yukon Territories')


Muthu T
Go to Top of Page

lookmemuthu
Starting Member

3 Posts
Posted - 2010-11-04 : 08:39:44
quote:
Originally posted by lookmemuthu

Is any Insert script for Province/Cities for Cananda?
-- script continuation

INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1,'ON','Barrie')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(2,'ON','Brampton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(3,'ON','Chatham-Kent')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(4,'ON','Guelph')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(5,'ON','Hamilton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(6,'ON','Kingston')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(7,'ON','Kitchener')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(8,'ON','London')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(9,'ON','Markham')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(10,'ON','North Bay')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(11,'ON','Mississauga')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(12,'ON','Oshawa')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(13,'ON','Peterborough')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(14,'ON','Richmond-Hill')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(15,'ON','St Catherines')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(16,'ON','Sudbury')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(17,'ON','Thunder Bay')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(18,'ON','Timmins')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(19,'ON','Vaughan')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(20,'ON','Windsor')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(21,'AB','Airdrie')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(22,'AB','Brooks')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(23,'AB','Calgary')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(24,'AB','Camrose')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(25,'AB','Cold Lake')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(26,'AB','Edmonton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(27,'AB','Fort Saskatchewan')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(28,'AB','Grande Prairie')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(29,'AB','Lacombe')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(30,'AB','Leduc')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(31,'AB','Lethbridge')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(32,'AB','Lloydminster')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(33,'AB','Medicine Hat')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(34,'AB','Red Deer')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(35,'AB','Spruce Grove')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(36,'AB','St. Albert')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(37,'AB','Wetaskiwin')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(38,'BC','Abbotsford')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(39,'BC','Armstrong')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(40,'BC','Burnaby')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(41,'BC','Campbell River')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(42,'BC','Castlegar')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(43,'BC','Chilliwack')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(44,'BC','Colwood')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(45,'BC','Coquitlam')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(46,'BC','Courtenay')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(47,'BC','Cranbrook')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(48,'BC','Dawson Creek')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(49,'BC','Duncan')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(50,'BC','Enderby')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(51,'BC','Fernie')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(52,'BC','Fort St. John')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(53,'BC','Grand Forks')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(54,'BC','Greenwood')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(55,'BC','Kamloops')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(56,'BC','Kelowna')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(57,'BC','Kimberley')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(58,'BC','Kitimat')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(59,'BC','Langford')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(60,'BC','Langley')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(61,'BC','Merritt')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(62,'BC','Nanaimo')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(63,'BC','Nelson')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(64,'BC','New Westminster')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(65,'BC','North Vancouver')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(66,'BC','Parksville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(67,'BC','Penticton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(68,'BC','Pitt Meadows')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(69,'BC','Port Alberni')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(70,'BC','Port Coquitlam')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(71,'BC','Port Moody')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(72,'BC','Powell River')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(73,'BC','Prince George')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(74,'BC','Prince Rupert')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(75,'BC','Prince Rupert')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(76,'BC','Quesnel')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(77,'BC','Revelstoke')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(78,'BC','Richmond')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(79,'BC','Rossland')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(80,'BC','Salmon Arm')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(81,'BC','Surrey')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(82,'BC','Terrace')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(83,'BC','Trail')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(84,'BC','Vancouver')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(85,'BC','Vernon')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(86,'BC','Victoria')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(87,'BC','White Rock')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(88,'BC','Williams Lake')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(89,'MB','Brandon')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(90,'MB','Dauphin')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(91,'MB','Flin Flon')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(92,'MB','Portage la Prairie')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(93,'MB','Selkirk')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(94,'MB','Steinbach')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(95,'MB','Thompson')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(96,'MB','Winkler')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(97,'MB','Winnipeg')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(98,'NB','Bathurst')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(99,'NB','Campbellton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(100,'NB','Dieppe')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(101,'NB','Edmundston')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(102,'NB','Fredericton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(103,'NB','Miramichi')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(104,'NB','Moncton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(105,'NB','Saint John')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(106,'NF','Corner Brook')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(107,'NF','Mount Pearl')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(108,'NF','St. John''s')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(109,'PE','Charlottetown')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(110,'PE','Summerside')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(111,'SK','Estevan')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(112,'SK','Flin Flon')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(113,'SK','Humboldt')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(114,'SK','Humboldt')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(115,'SK','Lloydminster')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(116,'SK','Martensville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(117,'SK','Meadow Lake')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(118,'SK','Melfort')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(119,'SK','Melville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(120,'SK','Moose Jaw')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(121,'SK','North Battleford')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(122,'SK','Prince Albert')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(123,'SK','Regina')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(124,'SK','Saskatoon')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(125,'SK','Swift Current')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(126,'SK','Weyburn')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(127,'SK','Yorkton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(128,'YT','Whitehorse')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(129,'NS','Advocate Harbour')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(130,'NS','Amherst')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(131,'NS','Annapolis Royal')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(132,'NS','Antigonish')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(133,'NS','Argyle')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(134,'NS','Arichat')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(135,'NS','Aylesford')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(136,'NS','Baddeck')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(137,'NS','Bass River')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(138,'NS','Bear River')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(139,'NS','Berwick')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(140,'NS','Blandford')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(141,'NS','Boisdale')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(142,'NS','Boularderie')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(143,'NS','Bridgetown')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(144,'NS','Bridgewater')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(145,'NS','Brookfield')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(146,'NS','Canning')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(147,'NS','Canso')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(148,'NS','Caribou')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(149,'NS','Carleton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(150,'NS','Chester')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(151,'NS','Cheticamp')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(152,'NS','Cheverie')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(153,'NS','Clarksville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(154,'NS','Clark`s Harbour')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(155,'NS','Collingwood Corner')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(156,'NS','Dartmouth')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(157,'NS','Debert')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(158,'NS','Digby')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(159,'NS','Dingwall')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(160,'NS','Dundee')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(161,'NS','East Bay')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(162,'NS','Ecum Secum')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(163,'NS','Elmsdale')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(164,'NS','Eskasoni')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(165,'NS','Freeport')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(166,'NS','French Village')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(167,'NS','Gabarus')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(168,'NS','Glace Bay')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(169,'NS','Goldboro')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(170,'NS','Goshen')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(171,'NS','Grand Etang')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(172,'NS','Grand Lake')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(173,'NS','Grand Manan')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(174,'NS','Grand Narrows')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(175,'NS','Great Village')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(176,'NS','Greenwood')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(177,'NS','Guysborough')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(178,'NS','Halifax')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(179,'NS','Hantsport')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(180,'NS','Heatherton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(181,'NS','Hopewell')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(182,'NS','Hubbards')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(183,'NS','Ingonish')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(184,'NS','Inverness')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(185,'NS','Kentville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(186,'NS','Kenzieville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(187,'NS','Ketch Harbour')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(188,'NS','Kingston')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(189,'NS','LaHave')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(190,'NS','Lake Charlotte')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(191,'NS','Larrys River')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(192,'NS','Lawrencetown')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(193,'NS','Liverpool')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(194,'NS','Lockeport')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(195,'NS','Louisbourg')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(196,'NS','Louisdale')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(197,'NS','Lunenburg')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(198,'NS','L`Ardoise')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(199,'NS','Mabou')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(200,'NS','Maccan')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(201,'NS','Mahone Bay')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(202,'NS','Maitland')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(203,'NS','Margaree Forks')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(204,'NS','Marion Bridge')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(205,'NS','Melrose')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(206,'NS','Merigomish')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(207,'NS','Meteghan')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(208,'NS','Middleton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(209,'NS','Monastery')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(210,'NS','Mount Uniacke')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(211,'NS','Mulgrave')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(212,'NS','Musquodoboit Harbour')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(213,'NS','New Germany')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(214,'NS','New Glasgow')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(215,'NS','New Ross')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(216,'NS','New Waterford')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(217,'NS','Noel')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(218,'NS','North Sydney')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(219,'NS','Oxford')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(220,'NS','Parrsboro')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(221,'NS','Peggy`s Cove')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(222,'NS','Pictou')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(223,'NS','Port Bickerton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(224,'NS','Port Dufferin')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(225,'NS','Port Greville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(226,'NS','Port Hawkesbury')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(227,'NS','Port Hood')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(228,'NS','Port La Tour')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(229,'NS','Port Maitland')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(230,'NS','Port Morien')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(231,'NS','Port Mouton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(232,'NS','Pubnico')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(233,'NS','Pugwash')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(234,'NS','Queensport')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(235,'NS','River Hebert')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(236,'NS','River John')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(237,'NS','Riverport')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(238,'NS','Salt Springs')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(239,'NS','Saulnierville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(240,'NS','Shelburne')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(241,'NS','Sherbrooke')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(242,'NS','Shubenacadie')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(243,'NS','Southampton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(244,'NS','Springfield')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(245,'NS','Springhill')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(246,'NS','St. Margaret Village')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(247,'NS','St. Peter`s')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(248,'NS','Stellarton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(249,'NS','Stewiacke')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(250,'NS','Sydney')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(251,'NS','Tangier')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(252,'NS','Tatamagouche')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(253,'NS','Thorburn')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(254,'NS','Trenton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(255,'NS','Truro')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(256,'NS','Tusket')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(257,'NS','Upper Musquodoboit')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(258,'NS','Upper Stewiacke')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(259,'NS','Wallace')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(260,'NS','Walton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(261,'NS','Waverley')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(262,'NS','Wedgeport')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(263,'NS','Westville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(264,'NS','Weymouth')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(265,'NS','Whycocomagh')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(266,'NS','Windsor')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(267,'NS','Wolfville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(268,'NS','Yarmouth')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(269,'PQ','Abercorn')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(270,'PQ','Acton Vale')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(271,'PQ','Adamsville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(272,'PQ','Aguanish')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(273,'PQ','Albanel')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(274,'PQ','Alma')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(275,'PQ','Alouette')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(276,'PQ','Amos')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(277,'PQ','Amqui')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(278,'PQ','Angliers')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(279,'PQ','Anjou')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(280,'PQ','Anse-Saint-Jean')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(281,'PQ','Armagh')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(282,'PQ','Arundel')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(283,'PQ','Asbestos')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(284,'PQ','Ascot')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(285,'PQ','Ascot Corner')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(286,'PQ','Ashuapmushuan')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(287,'PQ','Aston-Jonction')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(288,'PQ','Ayer`s Cliff')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(289,'PQ','Aylmer')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(290,'PQ','Bagotville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(291,'PQ','Baie-Comeau')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(292,'PQ','Baie-de-Shawinigan')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(293,'PQ','Baie-des-Sables')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(294,'PQ','Baie-du-Febvre')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(295,'PQ','Baie-d`Urfe')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(296,'PQ','Baie-Johan-Beetz')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(297,'PQ','Baie-Sainte-Catherine')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(298,'PQ','Baie-St-Paul')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(299,'PQ','Baie-Trinite')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(300,'PQ','Barachois')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(301,'PQ','Barkmere')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(302,'PQ','Barraute')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(303,'PQ','Batiscan')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(304,'PQ','Beaconsfield')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(305,'PQ','Beaucanton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(306,'PQ','Beauceville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(307,'PQ','Beauharnois')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(308,'PQ','Beaulac-Garthby')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(309,'PQ','Beaumont')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(310,'PQ','Beauport')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(311,'PQ','Beaupre')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(312,'PQ','Becancour')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(313,'PQ','Bedford')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(314,'PQ','Belle Neige')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(315,'PQ','Bellefeuille')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(316,'PQ','Belleterre')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(317,'PQ','Beloeil')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(318,'PQ','Bergeronnes')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(319,'PQ','Berthierville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(320,'PQ','Betsiamites')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(321,'PQ','Biencourt')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(322,'PQ','Bishopton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(323,'PQ','Black Lake')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(324,'PQ','Blainville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(325,'PQ','Blanc-Sablon')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(326,'PQ','Bois-des-Filion')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(327,'PQ','Boisbriand')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(328,'PQ','Boischatel')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(329,'PQ','Bonaventure')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(330,'PQ','Bonne-Esperance')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(331,'PQ','Boucherville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(332,'PQ','Bouchette')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(333,'PQ','Breakeyville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(334,'PQ','Brigham')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(335,'PQ','Brome')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(336,'PQ','Bromont')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(337,'PQ','Bromptonville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(338,'PQ','Brossard')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(339,'PQ','Brownsburg')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(340,'PQ','Bryson')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(341,'PQ','Buckingham')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(342,'PQ','Bury')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(343,'PQ','Cabano')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(344,'PQ','Cacouna')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(345,'PQ','Cadillac')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(346,'PQ','Calumet')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(347,'PQ','Campbell`s Bay')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(348,'PQ','Candiac')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(349,'PQ','Cantley')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(350,'PQ','Cap-a-l`Aigle')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(351,'PQ','Cap-aux-Meules')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(352,'PQ','Cap-Chat')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(353,'PQ','Cap-de-la-Madeleine')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(354,'PQ','Cap-des-Rosiers')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(355,'PQ','Cap-Rouge')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(356,'PQ','Cap-Saint-Ignace')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(357,'PQ','Caplan')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(358,'PQ','Carignan')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(359,'PQ','Carillon')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(360,'PQ','Carleton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(361,'PQ','Causapscal')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(362,'PQ','Chambly')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(363,'PQ','Chambord')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(364,'PQ','Champlain')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(365,'PQ','Chandler')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(366,'PQ','Chapais')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(367,'PQ','Chapeau')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(368,'PQ','Charette')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(369,'PQ','Charlemagne')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(370,'PQ','Charlesbourg')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(371,'PQ','Charlevoix')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(372,'PQ','Charny')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(373,'PQ','Chartierville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(374,'PQ','Chateau-Richer')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(375,'PQ','Chateauguay')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(376,'PQ','Chelsea')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(377,'PQ','Cheneville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(378,'PQ','Chesterville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(379,'PQ','Chevery')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(380,'PQ','Chibougamau')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(381,'PQ','Chicoutimi')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(382,'PQ','Chisasibi')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(383,'PQ','Chomedey')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(384,'PQ','Chute-aux-Outardes')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(385,'PQ','Chute-des-Passes')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(386,'PQ','Clericy')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(387,'PQ','Clermont')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(388,'PQ','Cloridorme')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(389,'PQ','Clova')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(390,'PQ','Coaticook')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(391,'PQ','Colombier')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(392,'PQ','Compton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(393,'PQ','Contrecoeur')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(394,'PQ','Cookshire')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(395,'PQ','Cote-St-Luc')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(396,'PQ','Coteau-du-Lac')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(397,'PQ','Courcelette')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(398,'PQ','Courcelles')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(399,'PQ','Cowansville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(400,'PQ','Crabtree')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(401,'PQ','Danville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(402,'PQ','Daveluyville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(403,'PQ','Deauville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(404,'PQ','Degelis')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(405,'PQ','Delisle')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(406,'PQ','Delson')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(407,'PQ','Desbiens')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(408,'PQ','Deschaillons-sur-Saint-Laurent')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(409,'PQ','Deux-Montagnes')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(410,'PQ','Disraeli')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(411,'PQ','Dolbeau-Mistassini')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(412,'PQ','Dollard-des-Ormeaux')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(413,'PQ','Donnacona')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(414,'PQ','Dorval')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(415,'PQ','Drummondville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(416,'PQ','Dubuisson')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(417,'PQ','Dunham')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(418,'PQ','Duparquet')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(419,'PQ','Dupuy')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(420,'PQ','Duvernay')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(421,'PQ','East Angus')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(422,'PQ','East Broughton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(423,'PQ','East Farnham')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(424,'PQ','East Hereford')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(425,'PQ','Eastmain')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(426,'PQ','Eastman')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(427,'PQ','Entrelacs')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(428,'PQ','Esterel')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(429,'PQ','Evain')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(430,'PQ','Fabre')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(431,'PQ','Fabreville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(432,'PQ','Falardeau')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(433,'PQ','Farnham')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(434,'PQ','Fassett')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(435,'PQ','Ferland')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(436,'PQ','Ferme-Neuve')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(437,'PQ','Fermont')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(438,'PQ','Fleurimont')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(439,'PQ','Forestville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(440,'PQ','Fort-Coulonge')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(441,'PQ','Fortierville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(442,'PQ','Fossambault-sur-le-Lac')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(443,'PQ','Frampton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(444,'PQ','Franklin Centre')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(445,'PQ','Frelighsburg')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(446,'PQ','Fugereville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(447,'PQ','Gaspe')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(448,'PQ','Gatineau')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(449,'PQ','Gentilly')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(450,'PQ','Girardville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(451,'PQ','Godbout')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(452,'PQ','Gracefield')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(453,'PQ','Granby')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(454,'PQ','Grand-Mere')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(455,'PQ','Grand-Remous')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(456,'PQ','Grande-Entree')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(457,'PQ','Grande-Riviere')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(458,'PQ','Grande-Vallee')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(459,'PQ','Grandes-Bergeronnes')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(460,'PQ','Grandes-Piles')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(461,'PQ','Greenfield Park')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(462,'PQ','Grenville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(463,'PQ','Guigues')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(464,'PQ','Ham-Nord')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(465,'PQ','Hammond')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(466,'PQ','Hampstead')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(467,'PQ','Harrington Harbour')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(468,'PQ','Havre-Aubert')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(469,'PQ','Havre-aux-Maisons')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(470,'PQ','Havre-St-Pierre')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(471,'PQ','Hebertville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(472,'PQ','Hebertville-Station')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(473,'PQ','Hemmingford')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(474,'PQ','Henryville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(475,'PQ','Howick')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(476,'PQ','Hudson')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(477,'PQ','Hull')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(478,'PQ','Huntingdon')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(479,'PQ','Iberville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(480,'PQ','Ile-aux-Coudres')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(481,'PQ','Iles-de-la-Madeleine')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(482,'PQ','Inukjuak')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(483,'PQ','Inverness')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(484,'PQ','Joliette')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(485,'PQ','Jonquiere')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(486,'PQ','Joutel')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(487,'PQ','Kangiqsualujjuaq')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(488,'PQ','Kangirsuk')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(489,'PQ','Kateville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(490,'PQ','Kazabazua')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(491,'PQ','Kingsbury')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(492,'PQ','Kingsey Falls')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(493,'PQ','Kirkland')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(494,'PQ','Knowlton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(495,'PQ','Kuujjuaq')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(496,'PQ','La Baie')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(497,'PQ','La Corne')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(498,'PQ','La Dore')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(499,'PQ','La Grande')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(500,'PQ','La Guadeloupe')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(501,'PQ','La Malbaie')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(502,'PQ','La Martre')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(503,'PQ','La Minerve')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(504,'PQ','La Patrie')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(505,'PQ','La Plaine')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(506,'PQ','La Pocatiere')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(507,'PQ','La Prairie')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(508,'PQ','La Reine')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(509,'PQ','La Romaine')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(510,'PQ','La Sarre')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(511,'PQ','La Tuque')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(512,'PQ','Labelle')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(513,'PQ','Lac Kenogami')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(514,'PQ','Lac-au-Saumon')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(515,'PQ','Lac-aux-Sables')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(516,'PQ','Lac-Bouchette')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(517,'PQ','Lac-Brome')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(518,'PQ','Lac-Delage')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(519,'PQ','Lac-des-Ecorces')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(520,'PQ','Lac-Drolet')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(521,'PQ','Lac-du-Cerf')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(522,'PQ','Lac-Edouard')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(523,'PQ','Lac-Etchemin')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(524,'PQ','Lac-Frontiere')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(525,'PQ','Lac-Poulin')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(526,'PQ','Lac-Saguay')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(527,'PQ','Lac-Sergent')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(528,'PQ','Lac-St-Joseph')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(529,'PQ','Lachenaie')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(530,'PQ','Lachine')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(531,'PQ','Lachute')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(532,'PQ','Lacolle')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(533,'PQ','Lafontaine')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(534,'PQ','Lake Megantic')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(535,'PQ','Lambton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(536,'PQ','Lanoraie')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(537,'PQ','LaSalle')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(538,'PQ','Laterriere')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(539,'PQ','Latulipe')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(540,'PQ','Laurentides')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(541,'PQ','Laurier-Station')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(542,'PQ','Laurierville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(543,'PQ','Laval')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(544,'PQ','Laval des Rapides')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(545,'PQ','Laval Ouest')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(546,'PQ','Lavaltrie')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(547,'PQ','Laverlochere')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(548,'PQ','Lawrenceville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(549,'PQ','Le Bic')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(550,'PQ','Le Gardeur')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(551,'PQ','Lebel-sur-Quevillon')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(552,'PQ','Leclercville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(553,'PQ','LeMoyne')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(554,'PQ','Lennoxville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(555,'PQ','Lery')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(556,'PQ','Les Boules')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(557,'PQ','Les Cedres')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(558,'PQ','Les Coteaux')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(559,'PQ','Les Eboulements')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(560,'PQ','Les Escoumins')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(561,'PQ','Les Mechins')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(562,'PQ','Levis')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(563,'PQ','Longueuil')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(564,'PQ','Loretteville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(565,'PQ','Lorraine')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(566,'PQ','Lorrainville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(567,'PQ','Louiseville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(568,'PQ','Lourdes de Blanc Sablon')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(569,'PQ','Louvicourt')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(570,'PQ','Low')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(571,'PQ','Luceville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(572,'PQ','Luskville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(573,'PQ','Lyster')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(574,'PQ','L`Acadie')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(575,'PQ','L`Ancienne-Lorette')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(576,'PQ','L`Ange-Gardien')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(577,'PQ','L`Annonciation')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(578,'PQ','L`Assomption')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(579,'PQ','L`Avenir')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(580,'PQ','L`Epiphanie')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(581,'PQ','L`Ile-Aux-Noix')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(582,'PQ','L`Ile-Bizard')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(583,'PQ','L`Ile-Cadieux')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(584,'PQ','L`Ile-Dorval')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(585,'PQ','L`Ile-d`Entree')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(586,'PQ','L`Ile-Perrot')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(587,'PQ','L`Île-Verte')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(588,'PQ','L`Islet')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(589,'PQ','Macamic')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(590,'PQ','Magog')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(591,'PQ','Malartic')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(592,'PQ','Manic-Cinq')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(593,'PQ','Maniwaki')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(594,'PQ','Manouane')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(595,'PQ','Manseau')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(596,'PQ','Mansonville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(597,'PQ','Maple Grove')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(598,'PQ','Maria')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(599,'PQ','Marieville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(600,'PQ','Marsoui')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(601,'PQ','Mascouche')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(602,'PQ','Maskinonge')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(603,'PQ','Masson-Angers')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(604,'PQ','Massueville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(605,'PQ','Mastigouche')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(606,'PQ','Matagami')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(607,'PQ','Matane')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(608,'PQ','Matapedia')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(609,'PQ','Mcmasterville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(610,'PQ','Melbourne')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(611,'PQ','Mellin')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(612,'PQ','Melocheville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(613,'PQ','Mercier')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(614,'PQ','Metabetchouan')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(615,'PQ','Metis-sur-Mer')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(616,'PQ','Mirabel')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(617,'PQ','Mistassini')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(618,'PQ','Moisie')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(619,'PQ','Mont Bechervaise')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(620,'PQ','Mont St Grégoire')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(621,'PQ','Mont-Joli')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(622,'PQ','Mont-Laurier')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(623,'PQ','Mont-Louis')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(624,'PQ','Mont-Rolland')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(625,'PQ','Mont-Royal')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(626,'PQ','Mont-St-Hilaire')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(627,'PQ','Mont-St-Pierre')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(628,'PQ','Mont-Tremblant')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(629,'PQ','Montebello')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(630,'PQ','Montmagny')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(631,'PQ','Montreal')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(632,'PQ','Montreal - Est')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(633,'PQ','Montréal - Nord')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(634,'PQ','Montréal - Ouest')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(635,'PQ','Morin-Heights')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(636,'PQ','Murdochville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(637,'PQ','Mutton Bay')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(638,'PQ','Nantes')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(639,'PQ','Napierville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(640,'PQ','Natashquan')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(641,'PQ','Nedelec')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(642,'PQ','Neuville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(643,'PQ','New Carlisle')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(644,'PQ','New Glasgow')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(645,'PQ','New Richmond')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(646,'PQ','Newport')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(647,'PQ','Nicolet')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(648,'PQ','Norbertville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(649,'PQ','Normandin')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(650,'PQ','Normetal')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(651,'PQ','North Hatley')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(652,'PQ','Notre Dame de Bonsecours')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(653,'PQ','Notre Dame de Lourdes')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(654,'PQ','Notre Dame De L`Ile Perrot')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(655,'PQ','Notre Dame des Laurentides')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(656,'PQ','Notre Dame Des Prairies')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(657,'PQ','Notre Dame Du Portage')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(658,'PQ','Notre-Dame-de-la-Paix')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(659,'PQ','Notre-Dame-de-la-Salette')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(660,'PQ','Notre-Dame-de-Stanbridge')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(661,'PQ','Notre-Dame-du-Bon-Conseil')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(662,'PQ','Notre-Dame-du-Lac')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(663,'PQ','Notre-Dame-du-Laus')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(664,'PQ','Notre-Dame-du-Nord')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(665,'PQ','Nouvelle')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(666,'PQ','Oka')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(667,'PQ','Omerville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(668,'PQ','Orford')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(669,'PQ','Ormstown')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(670,'PQ','Otterburn Park')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(671,'PQ','Outremont')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(672,'PQ','Palmarolle')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(673,'PQ','Papineauville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(674,'PQ','Parent')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(675,'PQ','Perce')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(676,'PQ','Peribonka')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(677,'PQ','Perkins')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(678,'PQ','Petite-Riviere-St-Francois')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(679,'PQ','Philipsburg')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(680,'PQ','Pierrefonds')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(681,'PQ','Pincourt')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(682,'PQ','Pintendre')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(683,'PQ','Plaisance')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(684,'PQ','Plessisville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(685,'PQ','Pohenegamook')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(686,'PQ','Pointe Aux Trembles')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(687,'PQ','Pointe-a-la-Croix')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(688,'PQ','Pointe-au-Pere')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(689,'PQ','Pointe-aux-Outardes')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(690,'PQ','Pointe-Calumet')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(691,'PQ','Pointe-Claire')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(692,'PQ','Pointe-des-Cascades')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(693,'PQ','Pointe-des-Monts')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(694,'PQ','Pointe-Fortune')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(695,'PQ','Pointe-Lebel')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(696,'PQ','Pont-Rouge')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(697,'PQ','Pont-Viau')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(698,'PQ','Pontiac')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(699,'PQ','Port-Cartier')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(700,'PQ','Port-Daniel')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(701,'PQ','Port-Menier')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(702,'PQ','Portneuf')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(703,'PQ','Poste-de-la-Baleine')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(704,'PQ','Prevost')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(705,'PQ','Price')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(706,'PQ','Princeville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(707,'PQ','Puvirnituq')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(708,'PQ','Quebec')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(709,'PQ','Quyon')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(710,'PQ','Radisson')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(711,'PQ','Rawdon')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(712,'PQ','Remigny')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(713,'PQ','Repentigny')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(714,'PQ','Réserve faunique de Rimouski')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(715,'PQ','Réserve faunique la Vérendrye')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(716,'PQ','Réserves fauniques de Matane e')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(717,'PQ','Richelieu')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(718,'PQ','Richmond')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(719,'PQ','Rigaud')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(720,'PQ','Rimouski')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(721,'PQ','Rimouski-Est')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(722,'PQ','Ripon')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(723,'PQ','Riviere-a-Pierre')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(724,'PQ','Riviere-au-Renard')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(725,'PQ','Riviere-au-Tonnerre')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(726,'PQ','Riviere-Beaudette')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(727,'PQ','Riviere-Bleue')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(728,'PQ','Riviere-du-Loup')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(729,'PQ','Riviere-Heva')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(730,'PQ','Riviere-St-Jean')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(731,'PQ','Robertsonville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(732,'PQ','Roberval')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(733,'PQ','Rochebaucourt')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(734,'PQ','Rock Forest')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(735,'PQ','Rollet')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(736,'PQ','Rosemere')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(737,'PQ','Rougemont')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(738,'PQ','Rouyn-Noranda')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(739,'PQ','Roxboro')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(740,'PQ','Roxton Falls')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(741,'PQ','Roxton Pond')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(742,'PQ','Sabrevois')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(743,'PQ','Sacre Coeur')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(744,'PQ','Saint Alexandre D`Iberville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(745,'PQ','Saint Alphonse de Granby')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(746,'PQ','Saint Amable')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(747,'PQ','Saint Antoine Des Laurentides')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(748,'PQ','Saint Antoine Sur Richelieu')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(749,'PQ','Saint Antonin')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(750,'PQ','Saint Athanase')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(751,'PQ','Saint Calixte')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(752,'PQ','Saint Charles Borromee')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(753,'PQ','Saint Charles Sur Richelieu')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(754,'PQ','Saint Christophe D`Arthabaska')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(755,'PQ','Saint Clair Beach')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(756,'PQ','Saint Colomban')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(757,'PQ','Saint Denis De Brompton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(758,'PQ','Saint Denis Sur Richelieu')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(759,'PQ','Saint Esprit')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(760,'PQ','aint Etienne de Beauharnois')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(761,'PQ','Saint Etienne de Beauharnois')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(762,'PQ','Saint Etienne de Lauzon')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(763,'PQ','Saint Gerard Majella')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(764,'PQ','Saint Isidore de la Prairie')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(765,'PQ','Saint Jean Baptiste')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(766,'PQ','Saint Jean D`Orleans')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(767,'PQ','Saint Joachim')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(768,'PQ','Saint Joseph De La Pointe De L')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(769,'PQ','Saint Laurent D`Orleans')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(770,'PQ','Saint Lazare De Vaudreuil')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(771,'PQ','Saint Lin Laurentides')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(772,'PQ','Saint Marc Sur Richelieu')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(773,'PQ','Saint Mathias Sur Richelieu')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(774,'PQ','Saint Mathieu de Beloeil')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(775,'PQ','Saint Mathieu de la Prairie')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(776,'PQ','Saint Maurice')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(777,'PQ','Saint Norbert D`Arthabaska')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(778,'PQ','Saint Paul D`Industrie')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(779,'PQ','Saint Philippe')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(780,'PQ','Saint Pierre D`Orleans')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(781,'PQ','Saint Robert')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(782,'PQ','Saint Roch De L`Achigan')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(783,'PQ','Saint Roch De Richelieu')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(784,'PQ','Saint Sulpice')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(785,'PQ','Saint Thomas')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(786,'PQ','Saint Urbain Premier')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(787,'PQ','Saint Valere')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(788,'PQ','Saint Victoire de Sorel')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(789,'PQ','Saint-Alexis-de-Montcalm')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(790,'PQ','Saint-Côme')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(791,'PQ','Saint-Donat')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(792,'PQ','Saint-Élie')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(793,'PQ','Saint-Élie-d`Orford')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(794,'PQ','Saint-Ferdinand')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(795,'PQ','Saint-Ferréol-les-neiges')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(796,'PQ','Saint-Hubert')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(797,'PQ','Saint-Hyacinthe')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(798,'PQ','Saint-Michel-des-Saints')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(799,'PQ','Sainte Angele De Monnoir')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(800,'PQ','Sainte Ann De Sorel')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(801,'PQ','Sainte Brigide D`Iberville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(802,'PQ','Sainte Cecile De Milton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(803,'PQ','Sainte Dorotheé')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(804,'PQ','Sainte Famille')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(805,'PQ','Sainte Marie Salome')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(806,'PQ','Sainte Marthe Du Cap')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(807,'PQ','Sainte Sophie')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(808,'PQ','Sainte Therese De Blainville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(809,'PQ','Salaberry-de-Valleyfield')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(810,'PQ','Salluit')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(811,'PQ','Sanmaur')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(812,'PQ','Sault-au-Mouton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(813,'PQ','Sawyerville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(814,'PQ','Sayabec')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(815,'PQ','Schefferville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(816,'PQ','Scotstown')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(817,'PQ','Senneterre')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(818,'PQ','Senneville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(819,'PQ','Sept-Iles')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(820,'PQ','Shawbridge')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(821,'PQ','Shawinigan')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(822,'PQ','Shawinigan-Sud')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(823,'PQ','Shawville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(824,'PQ','Shefford')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(825,'PQ','Sherbrooke')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(826,'PQ','Shigawake')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(827,'PQ','Shipshaw')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(828,'PQ','Sillery')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(829,'PQ','Sorel-Tracy')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(830,'PQ','Squatec')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(831,'PQ','St-Adelphe')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(832,'PQ','St-Adolphe-de-Dudswell')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(833,'PQ','St-Adolphe-d`Howard')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(834,'PQ','St-Agapit')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(835,'PQ','St-Aime')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(836,'PQ','St-Albert')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(837,'PQ','St-Alexandre-de-Kamouraska')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(838,'PQ','St-Alexis-de-Matapedia')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(839,'PQ','St-Alexis-des-Monts')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(840,'PQ','St-Alphonse-Rodriguez')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(841,'PQ','St-Andre')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(842,'PQ','St-Andre-Avellin')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(843,'PQ','St-Andre-du-Lac-St-Jean')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(844,'PQ','St-Andre-Est')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(845,'PQ','St-Anselme')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(846,'PQ','St-Antoine')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(847,'PQ','St-Antoine-de-Tilly')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(848,'PQ','St-Apollinaire')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(849,'PQ','St-Augustin-de-Desmaures')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(850,'PQ','St-Barnabe')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(851,'PQ','St-Barthelemy')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(852,'PQ','St-Basile')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(853,'PQ','St-Basile-le-Grand')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(854,'PQ','St-Basile-Sud')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(855,'PQ','St-Blaise-sur-Richelieu')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(856,'PQ','St-Boniface-de-Shawinigan')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(857,'PQ','St-Bruno')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(858,'PQ','St-Bruno-de-Montarville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(859,'PQ','St-Calixte-de-Kilkenny')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(860,'PQ','St-Casimir')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(861,'PQ','St-Celestin')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(862,'PQ','St-Cesaire')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(863,'PQ','St-Charles-de-Bellechasse')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(864,'PQ','St-Chrysostome')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(865,'PQ','St-Clet')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(866,'PQ','St-Constant')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(867,'PQ','St-Cyrille-de-Wendover')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(868,'PQ','St-Damase')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(869,'PQ','St-Damien-de-Buckland')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(870,'PQ','St-Denis')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(871,'PQ','St-Edouard-de-Lotbiniere')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(872,'PQ','St-Eleuthere')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(873,'PQ','St-Emile')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(874,'PQ','St-Emile-de-Suffolk')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(875,'PQ','St-Ephrem-de-Beauce')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(876,'PQ','St-Ephrem-de-Tring')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(877,'PQ','St-Eugene')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(878,'PQ','St-Eugene-de-Guigues')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(879,'PQ','St-Eustache')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(880,'PQ','St-Fabien-de-Panet')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(881,'PQ','St-Felicien')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(882,'PQ','St-Felix-de-Kingsey')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(883,'PQ','St-Felix-de-Valois')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(884,'PQ','St-Fidele-de-Mont-Murray')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(885,'PQ','St-Flavien')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(886,'PQ','St-Francois-du-Lac')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(887,'PQ','St-Fulgence')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(888,'PQ','St-Gabriel')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(889,'PQ','St-Gabriel-de-Brandon')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(890,'PQ','St-Gedeon')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(891,'PQ','St-Georges')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(892,'PQ','St-Georges-de-Beauce')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(893,'PQ','St-Georges-de-Cacouna')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(894,'PQ','St-Gerard')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(895,'PQ','St-Germain-de-Grantham')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(896,'PQ','St-Gregoire-de-Greenlay')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(897,'PQ','St-Guillaume')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(898,'PQ','St-Hilarion')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(899,'PQ','St-Hippolyte')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(900,'PQ','St-Honore-de-Beauce')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(901,'PQ','St-Honore-de-Chicoutimi')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(902,'PQ','St-Hugues')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(903,'PQ','St-Irenee')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(904,'PQ','St-Jacques')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(905,'PQ','St-Jean-Chrysostome')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(906,'PQ','St-Jean-de-Dieu')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(907,'PQ','St-Jean-de-Matha')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(908,'PQ','St-Jean-Port-Joli')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(909,'PQ','St-Jean-sur-Richelieu')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(910,'PQ','St-Jerome')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(911,'PQ','St-Joseph-de-Beauce')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(912,'PQ','St-Joseph-de-la-Rive')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(913,'PQ','St-Joseph-de-Sorel')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(914,'PQ','St-Jovite')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(915,'PQ','St-Jude')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(916,'PQ','St-Just-de-Bretenieres')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(917,'PQ','St-Lambert')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(918,'PQ','St-Lambert-de-Lauzon')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(919,'PQ','St-Laurent')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(920,'PQ','St-Leon-le-Grand')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(921,'PQ','St-Leonard')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(922,'PQ','St-Leonard-d`Aston')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(923,'PQ','St-Liboire')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(924,'PQ','St-Lin')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(925,'PQ','St-Louis-de-France')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(926,'PQ','St-Luc')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(927,'PQ','St-Ludger')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(928,'PQ','St-Magloire')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(929,'PQ','St-Malachie')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(930,'PQ','St-Malo')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(931,'PQ','St-Marc-des-Carrieres')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(932,'PQ','St-Methode-de-Frontenac')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(933,'PQ','St-Michel-de-Bellechasse')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(934,'PQ','St-Moose')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(935,'PQ','St-Nazaire-d`Acton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(936,'PQ','St-Nicolas')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(937,'PQ','St-Noel')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(938,'PQ','St-Odilon-de-Cranbourne')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(939,'PQ','St-Ours')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(940,'PQ','St-Pacome')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(941,'PQ','St-Pamphile')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(942,'PQ','St-Pascal')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(943,'PQ','St-Patrice-de-Beaurivage')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(944,'PQ','St-Paul-de-Montminy')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(945,'PQ','St-Paul-d`Abbotsford')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(946,'PQ','St-Paulin')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(947,'PQ','St-Philippe-de-Neri')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(948,'PQ','St-Pie')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(949,'PQ','St-Pie-de-Guire')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(950,'PQ','St-Pierre')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(951,'PQ','St-Pierre-de-Wakefield')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(952,'PQ','St-Pierre-les-Becquets')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(953,'PQ','St-Polycarpe')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(954,'PQ','St-Prime')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(955,'PQ','St-Prosper-de-Dorchester')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(956,'PQ','St-Raymond')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(957,'PQ','St-Redempteur')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(958,'PQ','St-Remi')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(959,'PQ','St-Rene-de-Matane')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(960,'PQ','St-Roch-de-Mekinac')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(961,'PQ','St-Roch-des-Aulnaies')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(962,'PQ','St-Romuald')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(963,'PQ','St-Sauveur')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(964,'PQ','St-Sauveur-des-Monts')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(965,'PQ','St-Simeon')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(966,'PQ','St-Simon-de-Bagot')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(967,'PQ','St-Simon-de-Rimouski')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(968,'PQ','St-Sylvere')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(969,'PQ','St-Sylvestre')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(970,'PQ','St-Theophile')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(971,'PQ','St-Thomas-d`Aquin')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(972,'PQ','St-Timothee')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(973,'PQ','St-Tite')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(974,'PQ','St-Tite-des-Caps')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(975,'PQ','St-Ubalde')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(976,'PQ','St-Ulric')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(977,'PQ','St-Urbain')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(978,'PQ','St-Victor')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(979,'PQ','St-Wenceslas')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(980,'PQ','St-Zacharie')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(981,'PQ','St-Zenon')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(982,'PQ','St-Zephirin')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(983,'PQ','St-Zotique')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(984,'PQ','St. Ambroise de Chicoutimi')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(985,'PQ','St. Basile de Portneuf')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(986,'PQ','St. Bernard de Dorchester')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(987,'PQ','St. Come de Kennebec')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(988,'PQ','St. Edouard de Frampton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(989,'PQ','St. Fabien de Rimouski')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(990,'PQ','St. Ferdinand d`Halifax')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(991,'PQ','St. Fidele')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(992,'PQ','St. Gabriel de Rimouski')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(993,'PQ','St. Gedeon de Beauce')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(994,'PQ','St. Gregoire de Nicolet')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(995,'PQ','St. Henri de Levis')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(996,'PQ','St. Honore')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(997,'PQ','St. Leon De Chic.')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(998,'PQ','St. Martin de Beauce')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(999,'PQ','St. Moise')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1000,'PQ','St. Raphael de Bellechasse')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1001,'PQ','St. Sebastien')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1002,'PQ','St. Theodore de Chertsey')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1003,'PQ','St. Victor de Beauce')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1004,'PQ','St. Vincent de Paul')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1005,'PQ','Stanstead')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1006,'PQ','Ste-Adele')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1007,'PQ','Ste-Agathe')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1008,'PQ','Ste-Agathe-des-Monts')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1009,'PQ','Ste-Agathe-Sud')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1010,'PQ','Ste-Anne-de-Beaupre')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1011,'PQ','Ste-Anne-de-Bellevue')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1012,'PQ','Ste-Anne-de-la-Perade')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1013,'PQ','Ste-Anne-de-Portneuf')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1014,'PQ','Ste-Anne-des-Monts')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1015,'PQ','Ste-Anne-des-Plaines')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1016,'PQ','Ste-Anne-du-Lac')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1017,'PQ','Ste-Blandine')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1018,'PQ','Ste-Brigitte-de-Laval')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1019,'PQ','Ste-Catherine')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1020,'PQ','Ste-Clotilde-de-Horton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1021,'PQ','Ste-Eulalie')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1022,'PQ','Ste-Felicite')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1023,'PQ','Ste-Foy')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1024,'PQ','Ste-Genevieve')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1025,'PQ','Ste-Helene-de-Bagot')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1026,'PQ','Ste-Henedine')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1027,'PQ','Ste-Jeanne-d`Arc')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1028,'PQ','Ste-Julie')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1029,'PQ','Ste-Julie-de-Vercheres')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1030,'PQ','Ste-Justine')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1031,'PQ','Ste-Julienne')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1032,'PQ','Ste-Lucie-de-Beauregard')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1033,'PQ','Ste-Madeleine')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1034,'PQ','Ste-Marguerite')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1035,'PQ','Ste-Marie-de-Beauce')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1036,'PQ','Ste-Marie-de-Blandford')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1037,'PQ','Ste-Marthe')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1038,'PQ','Ste-Marthe-sur-le-Lac')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1039,'PQ','Ste-Perpetue')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1040,'PQ','Ste-Petronille')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1041,'PQ','Ste-Rosalie')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1042,'PQ','Ste-Rose')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1043,'PQ','Ste-Rose-de-Watford')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1044,'PQ','Ste-Rose-du-Nord')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1045,'PQ','Ste-Sophie-de-Levrard')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1046,'PQ','Ste-Thecle')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1047,'PQ','Ste-Therese')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1048,'PQ','Ste-Veronique')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1049,'PQ','Ste-Victoire')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1050,'PQ','Ste. Agathe de Lotbiniere')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1051,'PQ','Ste. Angele de Laval')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1052,'PQ','Ste. Cecile Masham')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1053,'PQ','Ste. Claire de Dorchester')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1054,'PQ','Ste. Croix de Lotbiniere')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1055,'PQ','Ste. Gertrude')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1056,'PQ','Ste. Justine de Newton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1057,'PQ','Ste. Martine')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1058,'PQ','Ste. Methode de Frontenac')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1059,'PQ','Ste. Monique de Nicolet')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1060,'PQ','Ste. Rose du Lac')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1061,'PQ','Stoke')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1062,'PQ','Stoneham')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1063,'PQ','Stratford')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1064,'PQ','Stukely-Sud')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1065,'PQ','Sutton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1066,'PQ','Tadoussac')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1067,'PQ','Taschereau')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1068,'PQ','Tasiujaq')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1069,'PQ','Temiscaming')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1070,'PQ','Terrasse Vaudreuil')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1071,'PQ','Terrebonne')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1072,'PQ','Tete-a-la-Baleine')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1073,'PQ','Thetford Mines')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1074,'PQ','Thurso')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1075,'PQ','Tingwick')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1076,'PQ','Tremblay')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1077,'PQ','Tring-Jonction')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1078,'PQ','Trois-Pistoles')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1079,'PQ','Trois-Rivieres')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1080,'PQ','Umiujaq')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1081,'PQ','Upton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1082,'PQ','Val-Alain')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1083,'PQ','Val-Barrette')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1084,'PQ','Val-Belair')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1085,'PQ','Val-Brillant')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1086,'PQ','Val-David')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1087,'PQ','Val-des-Bois')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1088,'PQ','Val-d`Or')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1089,'PQ','Valcartier')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1090,'PQ','Valcourt')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1091,'PQ','Vallee-Jonction')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1092,'PQ','Vanier')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1093,'PQ','Varennes')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1094,'PQ','Vaudreuil')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1095,'PQ','Vaudreuil Dorion')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1096,'PQ','Vaudreuil-sur-le-Lac')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1097,'PQ','Venise-en-Quebec')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1098,'PQ','Vercheres')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1099,'PQ','Verdun')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1100,'PQ','Victoriaville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1101,'PQ','Ville-Marie')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1102,'PQ','Vimont')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1103,'PQ','Wakefield')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1104,'PQ','Warden')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1105,'PQ','Warwick')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1106,'PQ','Waskaganish')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1107,'PQ','Waswanipi')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1108,'PQ','Waterloo')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1109,'PQ','Waterville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1110,'PQ','Weedon')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1111,'PQ','Weedon Centre')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1112,'PQ','Wemindji')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1113,'PQ','Wendover')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1114,'PQ','Westbury')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1115,'PQ','Westmount')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1116,'PQ','Wickham')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1117,'PQ','Windsor')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1118,'PQ','Woburn')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1119,'PQ','Wotton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1120,'PQ','Yamachiche')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1121,'PQ','Yamaska')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1122,'PQ','Yamaska-Est')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1123,'CO','Adams')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1124,'CO','Alamosa')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1125,'CO','Arapahoe')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1126,'CO','Archuleta')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1127,'CO','Baca')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1128,'CO','Bent')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1129,'CO','Boulder')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1130,'CO','Broomfield')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1131,'CO','Chaffee')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1132,'CO','Cheyenne')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1133,'CO','Clear Creek')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1134,'CO','Conejos')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1135,'CO','Costilla')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1136,'CO','Crowley')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1137,'CO','Custer')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1138,'CO','Delta')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1139,'CO','Denver')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1140,'CO','Dolores')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1141,'CO','Douglas')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1142,'CO','Eagle')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1143,'CO','El Pasco')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1144,'CO','Elbert')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1145,'CO','Fremont')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1146,'CO','Garfield')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1147,'CO','Gilpin')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1148,'CO','Grand')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1149,'CO','Gunnison')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1150,'CO','Hinsdale')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1151,'CO','Huerfano')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1152,'CO','Jackson')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1153,'CO','Jefferson')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1154,'CO','Kiowa')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1155,'CO','Kit Carson')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1156,'CO','La Plata')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1157,'CO','Lake')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1158,'CO','Larimer')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1159,'CO','Las Animas')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1160,'CO','Lincoln')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1161,'CO','Logan')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1162,'CO','Mesa')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1163,'CO','Mineral')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1164,'CO','Moffat')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1165,'CO','Montezuma')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1166,'CO','Montroze')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1167,'CO','Morgan')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1168,'CO','Otero')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1169,'CO','Ouray')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1170,'CO','Park')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1171,'CO','Phillips')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1172,'CO','Pitkin')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1173,'CO','Prowers')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1174,'CO','Pueblo')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1175,'CO','Rio Blanco')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1176,'CO','Rio Grande')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1177,'CO','Routt')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1178,'CO','Saguache')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1179,'CO','San Juan')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1180,'CO','San Miguel')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1181,'CO','Sedqwick')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1182,'CO','Summit')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1183,'CO','Teller')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1184,'CO','Washington')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1185,'CO','Weld')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1186,'CO','Yuma')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1187,'CT','Ansonia')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1188,'CT','Bridgeport')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1189,'CT','Bristol')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1190,'CT','Danbury')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1191,'CT','Derby')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1192,'CT','Groton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1193,'CT','Hartford')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1194,'CT','Meriden')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1195,'CT','Middletown')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1196,'CT','Milford')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1197,'CT','New Britain')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1198,'CT','New Haven')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1199,'CT','New London')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1200,'CT','Norwalk')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1201,'CT','Norwich')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1202,'CT','Shelton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1203,'CT','Stamford')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1204,'CT','Torrington')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1205,'CT','Waterbury')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1206,'CT','West Haven')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1207,'CT','Winsted')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1208,'CT','Winchester')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1209,'DE','Delaware')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1210,'DE','Wilmington')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1211,'DE','Dover')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1212,'DE','Newark')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1213,'DE','Middletown')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1214,'DE','Smyrna')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1215,'DE','Milford')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1216,'DE','Seaford')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1217,'DE','Elsmere')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1218,'DE','Georgetown')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1219,'DE','New Castle')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1220,'DE','Laurel')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1221,'DE','Harrington')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1222,'DE','Lewes')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1223,'DE','Millsboro')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1224,'DE','Camden')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1225,'DE','Milton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1226,'DE','Selbyville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1227,'DE','Bridgeville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1228,'DE','Rehoboth Beach')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1229,'DE','Delaware City')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1230,'DE','Delmar')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1231,'DE','Clayton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1232,'DE','Bellefonte')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1233,'DE','Wyoming')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1234,'DE','Newport')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1235,'DE','Ocean View')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1236,'DE','Blades')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1237,'DE','Bethany Beach')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1238,'DE','Greenwood')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1239,'DE','Felton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1240,'DE','Frankford')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1241,'DE','Frederica')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1242,'DE','Dagsboro')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1243,'DE','South Bethany')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1244,'DE','Arden')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1245,'DE','Houston')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1246,'DE','Townsend')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1247,'DE','Fenwick Island')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1248,'DE','Cheswold')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1249,'DE','Ellendale')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1250,'DE','Bowers')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1251,'DE','Odessa')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1252,'DE','Dewey Beach')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1253,'DE','Ardentown')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1254,'DE','Ardencroft')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1255,'DE','Millville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1256,'DE','Kenton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1257,'DE','Magnolia')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1258,'DE','Leipsic')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1259,'DE','Slaughter Beach')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1260,'DE','Little Creek')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1261,'DE','Bethel')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1262,'DE','Woodside')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1263,'DE','Viola')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1264,'DE','Henlopen Acres')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1265,'DE','Hartly')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1266,'DE','Farmington')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1267,'ND','Fargo')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1268,'ND','Bismarck')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1269,'ND','Grand Forks')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1270,'ND','Minot')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1271,'ND','West Fargo')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1272,'ND','Mandan')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1273,'ND','Dickinson')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1274,'ND','Jamestown')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1275,'ND','Williston')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1276,'ND','Wahpeton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1277,'ND','Devils Lake')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1278,'ND','Valley City')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1279,'ND','Grafton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1280,'ND','Beulah')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1281,'ND','Lincoln')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1282,'ND','Rugby')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1283,'ND','Hazen')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1284,'ND','Lisbon')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1285,'ND','Horace')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1286,'ND','Bottineau')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1287,'ND','Casselton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1288,'ND','Carrington')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1289,'ND','New Town')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1290,'ND','Mayville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1291,'ND','Oakes')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1292,'ND','Langdon')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1293,'ND','Harvey')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1294,'ND','Bowman')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1295,'ND','Hillsboro')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1296,'ND','Ellendale')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1297,'ND','Rolla')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1298,'ND','Watford City')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1299,'ND','Park River')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1300,'ND','Cavalier')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1301,'ND','Larimore')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1302,'ND','Stanley')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1303,'ND','Washburn')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1304,'ND','New Rockford')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1305,'ND','Garrison')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1306,'ND','Hettinger')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1307,'ND','Tioga')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1308,'ND','Kenmare')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1309,'ND','Parshall')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1310,'ND','Cando')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1311,'ND','Linton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1312,'ND','Burlington')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1313,'ND','Enderlin')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1314,'ND','Hankinson')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1315,'ND','Thompson')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1316,'ND','Crosby')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1317,'ND','Beach')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1318,'ND','Northwood')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1319,'ND','Velva')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1320,'ND','Surrey')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1321,'ND','Cooperstown')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1322,'ND','Walhalla')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1323,'ND','New Salem')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1324,'ND','Wishek')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1325,'ND','Belfield')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1326,'ND','Glen Ullin')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1327,'ND','LaMoure')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1328,'ND','Drayton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1329,'ND','Mapleton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1330,'ND','Dunseith')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1331,'ND','Hebron')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1332,'ND','Wilton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1333,'ND','Harwood')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1334,'ND','Underwood')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1335,'SD','Sioux Falls')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1336,'SD','Rapid City')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1337,'SD','Aberdeen')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1338,'SD','Watertown')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1339,'SD','Brookings')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1340,'SD','Mitchell')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1341,'SD','Pierre')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1342,'SD','Yankton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1343,'SD','Huron')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1344,'SD','Vermillion')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1345,'SD','Spearfish')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1346,'SD','Brandon')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1347,'SD','Madison')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1348,'SD','Sturgis')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1349,'SD','Belle Fourche')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1350,'SD','Harrisburg')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1351,'SD','Hot Springs')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1352,'SD','Tea')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1353,'SD','Canton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1354,'SD','Box Elder')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1355,'SD','Dell Rapids')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1356,'SD','Milbank')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1357,'SD','Mobridge')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1358,'SD','Lead')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1359,'SD','Winner')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1360,'SD','North Sioux City')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1361,'SD','Sisseton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1362,'SD','Hartford')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1363,'SD','Lennnox')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1364,'SD','Redfield')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1365,'SD','Chamberlain')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1366,'SD','Flandreau')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1367,'SD','Beresford')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1368,'SD','Fort Pierre')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1369,'SD','Custer')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1370,'SD','Elk Point')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1371,'SD','Webster')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1372,'SD','Volga')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1373,'SD','Wagner')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1374,'SD','Springfield')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1375,'SD','Parkston')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1376,'SD','Groton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1377,'SD','Miller')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1378,'SD','Salem')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1379,'SD','Platte')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1380,'SD','Deadwood')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1381,'SD','Britton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1382,'SD','Clear Lake')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1383,'SD','Mission')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1384,'SD','Crooks')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1385,'SD','Garretson')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1386,'SD','Freeman')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1387,'SD','Lemmon')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1388,'SD','Gregory')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1389,'SD','Tyndall')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1390,'SD','Clark')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1391,'SD','Gettysbarg')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1392,'SD','De Smet')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1393,'SD','Baltic')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1394,'NT','Fort Liard')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1395,'NT','Fort Simpson')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1396,'NT','Fort Smith')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1397,'NT','Hay River')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1398,'NT','Inuvik')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1399,'NT','Norman Wells')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1400,'NT','YellowKnife')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1401,'PE','Charlottetown')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1402,'PE','Summerside')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1403,'PM','Koror')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1404,'WY','Albany')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1405,'WY','Big Horn')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1406,'WY','Campbell')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1407,'WY','Carbon')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1408,'WY','Converse')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1409,'WY','Crook')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1410,'WY','Fremont')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1411,'WY','Goshen')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1412,'WY','Hot Springs')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1413,'WY','Johnson')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1414,'WY','Laramie')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1415,'WY','Lincoln')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1416,'WY','Natrona')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1417,'WY','Niobrara')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1418,'WY','Park')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1419,'WY','Platte')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1420,'WY','Sheridan')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1421,'WY','Sublette')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1422,'WY','Sweetwater')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1423,'WY','Teton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1424,'WY','Uinta')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1425,'WY','Washakie')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1426,'WY','Weston')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1427,'WV','Beckley')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1428,'WV','Belmont')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1429,'WV','Benwood')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1430,'WV','Berkeley Springs')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1431,'WV','Bluefield')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1432,'WV','Bridgeport')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1433,'WV','Buckhannon')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1434,'WV','Buffalo')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1435,'WV','Burnsville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1436,'WV','Barboursville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1437,'WV','Cameron')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1438,'WV','Ceredo')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1439,'WV','Charles Town')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1440,'WV','Charleston')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1441,'WV','Chester')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1442,'WV','Clarksburg')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1443,'WV','Cyclone')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1444,'WV','Dunbar')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1445,'WV','Elkins')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1446,'WV','Fairmont')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1447,'WV','Fayetteville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1448,'WV','Follansbee')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1449,'WV','Gary')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1450,'WV','Glen Dale')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1451,'WV','Grafton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1452,'WV','Hinton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1453,'WV','Huntington')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1454,'WV','Hurricane')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1455,'WV','Hedgesville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1456,'WV','Iaeger')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1457,'WV','Kenova')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1458,'WV','Keyser')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1459,'WV','Keystone')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1460,'WV','Kingwood')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1461,'WV','Lewisburg')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1462,'WV','Logan')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1463,'WV','Madison')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1464,'WV','Mannington')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1465,'WV','Marmet')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1466,'WV','Martinsburg')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1467,'WV','Masontown')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1468,'WV','McMechen')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1469,'WV','Montgomery')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1470,'WV','Morgantown')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1471,'WV','Moundsville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1472,'WV','Mount Hope')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1473,'WV','Mullens')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1474,'WV','New Cumberland')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1475,'WV','Newell')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1476,'WV','New Martinsville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1477,'WV','Nitro')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1478,'WV','Oak Hill')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1479,'WV','Oceana')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1480,'WV','Paden City')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1481,'WV','Parkersburg')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1482,'WV','Parsons')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1483,'WV','Pennsboro')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1484,'WV','Petersburg')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1485,'WV','Philippi')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1486,'WV','Pleasant Valley')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1487,'WV','Point Pleasant')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1488,'WV','Princeton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1489,'WV','Ravenswood')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1490,'WV','Richwood')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1491,'WV','Ripley')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1492,'WV','Romney')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1493,'WV','Ronceverte')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1494,'WV','Salem')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1495,'WV','Shepherdstown')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1496,'WV','Shinnston')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1497,'WV','Sistersville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1498,'WV','Smithers')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1499,'WV','South Charleston')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1500,'WV','Spencer')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1501,'WV','St. Albans')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1502,'WV','St. Marys')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1503,'WV','Stonewood')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1504,'WV','Sutton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1505,'WV','Thomas')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1506,'WV','Vienna')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1507,'WV','War')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1508,'WV','Wayne')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1509,'WV','Weirton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1510,'WV','Welch')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1511,'WV','Wellsburg')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1512,'WV','Weston')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1513,'WV','Westover')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1514,'WV','Wheeling')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1515,'WV','White Sulphur Springs')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1516,'WV','Williamson')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1517,'WV','Williamstown')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1518,'VI','Anna''s Retreat')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1519,'VI','Charlotte Amalie')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1520,'VI','Charlotte Amalie East')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1521,'VI','Charlotte Amalie West')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1522,'VI','Christiansted')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1523,'VI','Cruz Bay')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1524,'VI','Frederiksted')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1525,'VI','Frederiksted Southeast')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1526,'VI','Grove Place')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1527,'VI','Tutu')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1528,'RI','Barrington')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1529,'RI','Bristol')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1530,'RI','Burrillville')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1531,'RI','Central Falls')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1532,'RI','Charlestown')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1533,'RI','Coventry')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1534,'RI','Cranston')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1535,'RI','Cumberland')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1536,'RI','East Greenwich')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1537,'RI','East Providence')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1538,'RI','Exeter')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1539,'RI','Foster')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1540,'RI','Glocester')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1541,'RI','Hopkinton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1542,'RI','Jamestown')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1543,'RI','Johnston')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1544,'RI','Lincoln')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1545,'RI','Little Compton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1546,'RI','Middletown')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1547,'RI','Narragansett')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1548,'RI','New Shoreham (Block Island)')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1549,'RI','Newport')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1550,'RI','North Kingstown')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1551,'RI','North Providence')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1552,'RI','North Smithfield')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1553,'RI','Pawtucket')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1554,'RI','Portsmouth')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1555,'RI','Providence')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1556,'RI','Richmond')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1557,'RI','Scituate')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1558,'RI','Smithfield')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1559,'RI','South Kingstown')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1560,'RI','Tiverton')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1561,'RI','Warren')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1562,'RI','Warwick')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1563,'RI','West Greenwich')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1564,'RI','West Warwick')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1565,'RI','Westerly')
INSERT INTO [Cities] ([CityID],[StateCode],[CityName])VALUES(1566,'RI','Woonsocket')
Muthu T


Muthu T
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site