Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2010
    Posts
    3

    Unanswered: CanadianCitiesInsertScript

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

  2. #2
    Join Date
    Nov 2010
    Posts
    3

    Canada ProvincesInsertScript

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

  3. #3
    Join Date
    Nov 2010
    Posts
    3

    ProvincesCities Script

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

    Thanks,
    Muthu T.
    Attached Files Attached Files

  4. #4
    Join Date
    Sep 2009
    Location
    Ontario
    Posts
    1,057
    Provided Answers: 1
    Additions: "NU,1,Nunavut"
    Changes: "NL,1,Newfoundland & Labrador" was NF

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •