I need script for Canadian provinces and their cities? Could any one help me?

Insert scripts for provinces:

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')

Attached script can have create and insert scripts for cananda provinces and their cities.

Thanks,
Muthu T.

Additions: "NU,1,Nunavut"
Changes: "NL,1,Newfoundland & Labrador" was NF