FRENCH PROVINCE / Départements français

INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Ain','01',1)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Aisne','02',2)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Allier','03',3)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Alpes-de-Haute-Provence','04',4)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Hautes-Alpes','05',5)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Alpes-Maritimes','06',6)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Ardèche','07',7)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Ardennes','08',8)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Ariège','09',9)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Aube','10',10)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Aude','11',11)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Aveyron','12',12)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Bouches-du-Rhône','13',13)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Calvados','14',14)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Cantal','15',15)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Charente','16',16)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Charente-Maritime','17',17)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Cher','18',18)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Corrèze','19',19)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Corse-du-Sud','2A',20)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Haute-Corse','2B',21)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Côte-d''Or','21',22)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Côtes-d''Armor','22',23)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Creuse','23',24)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Dordogne','24',25)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Doubs','25',26)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Drôme','26',27)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Eure','27',28)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Eure-et-Loir','28',29)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Finistère','29',30)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Gard','30',31)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Haute-Garonne','31',32)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Gers','32',33)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Gironde','33',34)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Hérault','34',35)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Ille-et-Vilaine','35',36)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Indre','36',37)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Indre-et-Loire','37',38)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Isère','38',39)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Jura','39',40)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Landes','40',41)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Loir-et-Cher','41',42)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Loire','42',43)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Haute-Loire','43',44)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Loire-Atlantique','44',45)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Loiret','45',46)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Lot','46',47)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Lot-et-Garonne','47',48)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Lozère','48',49)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Maine-et-Loire','49',50)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Manche','50',51)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Marne','51',52)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Haute-Marne','52',53)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Mayenne','53',54)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Meurthe-et-Moselle','54',55)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Meuse','55',56)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Morbihan','56',57)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Moselle','57',58)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Nièvre','58',59)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Nord','59',60)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Oise','60',61)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Orne','61',62)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Pas-de-Calais','62',63)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Puy-de-Dôme','63',64)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Pyrénées-Atlantiques','64',65)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Hautes-Pyrénées','65',66)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Pyrénées-Orientales','66',67)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Bas-Rhin','67',68)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Haut-Rhin','68',69)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Rhône','69',70)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Haute-Saône','70',71)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Saône-et-Loire','71',72)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Sarthe','72',73)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Savoie','73',74)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Haute-Savoie','74',75)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Paris','75',76)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Seine-Maritime','76',77)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Seine-et-Marne','77',78)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Yvelines','78',79)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Deux-Sèvres','79',80)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Somme','80',81)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Tarn','81',82)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Tarn-et-Garonne','82',83)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Var','83',84)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Vaucluse','84',85)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Vendée','85',86)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Vienne','86',87)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Haute-Vienne','87',88)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Vosges','88',89)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Yonne','89',90)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Territoire de Belfort','90',91)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Essonne','91',92)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Hauts-de-Seine','92',93)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Seine-Saint-Denis','93',94)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Val-de-Marne','94',95)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Val-d''Oise','95',96)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Guadeloupe','971',97)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Martinique','972',98)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Guyane','973',99)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'La Réunion','974',100)
INSERT INTO [dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder]) VALUES(33,'Mayotte','976',101)

I just updated the list with the new nopCommerce Table Stucture

Hope can help sameone

INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Ain','01',1,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Aisne','02',2,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Allier','03',3,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Alpes-de-Haute-Provence','04',4,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Hautes-Alpes','05',5,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Alpes-Maritimes','06',6,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Ardèche','07',7,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Ardennes','08',8,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Ariège','09',9,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Aube','10',10,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Aude','11',11,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Aveyron','12',12,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Bouches-du-Rhône','13',13,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Calvados','14',14,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Cantal','15',15,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Charente','16',16,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Charente-Maritime','17',17,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Cher','18',18,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Corrèze','19',19,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Corse-du-Sud','2A',20,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Haute-Corse','2B',21,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Côte-d''Or','21',22,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Côtes-d''Armor','22',23,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Creuse','23',24,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Dordogne','24',25,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Doubs','25',26,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Drôme','26',27,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Eure','27',28,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Eure-et-Loir','28',29,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Finistère','29',30,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Gard','30',31,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Haute-Garonne','31',32,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Gers','32',33,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Gironde','33',34,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Hérault','34',35,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Ille-et-Vilaine','35',36,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Indre','36',37,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Indre-et-Loire','37',38,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Isère','38',39,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Jura','39',40,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Landes','40',41,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Loir-et-Cher','41',42,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Loire','42',43,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Haute-Loire','43',44,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Loire-Atlantique','44',45,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Loiret','45',46,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Lot','46',47,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Lot-et-Garonne','47',48,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Lozère','48',49,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Maine-et-Loire','49',50,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Manche','50',51,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Marne','51',52,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Haute-Marne','52',53,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Mayenne','53',54,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Meurthe-et-Moselle','54',55,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Meuse','55',56,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Morbihan','56',57,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Moselle','57',58,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Nièvre','58',59,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Nord','59',60,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Oise','60',61,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Orne','61',62,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Pas-de-Calais','62',63,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Puy-de-Dôme','63',64,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Pyrénées-Atlantiques','64',65,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Hautes-Pyrénées','65',66,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Pyrénées-Orientales','66',67,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Bas-Rhin','67',68,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Haut-Rhin','68',69,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Rhône','69',70,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Haute-Saône','70',71,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Saône-et-Loire','71',72,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Sarthe','72',73,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Savoie','73',74,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Haute-Savoie','74',75,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Paris','75',76,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Seine-Maritime','76',77,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Seine-et-Marne','77',78,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Yvelines','78',79,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Deux-Sèvres','79',80,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Somme','80',81,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Tarn','81',82,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Tarn-et-Garonne','82',83,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Var','83',84,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Vaucluse','84',85,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Vendée','85',86,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Vienne','86',87,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Haute-Vienne','87',88,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Vosges','88',89,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Yonne','89',90,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Territoire de Belfort','90',91,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Essonne','91',92,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Hauts-de-Seine','92',93,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Seine-Saint-Denis','93',94,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Val-de-Marne','94',95,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Val-d''Oise','95',96,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Guadeloupe','971',97,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Martinique','972',98,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Guyane','973',99,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'La Réunion','974',100,1)
INSERT INTO [StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder],[Published]) VALUES(33,'Mayotte','976',101,1)

FRENCH PROVINCE / Départements français

Ainda tem dúvidas ou precisa de ajuda?