Italian stateProvince nopCommerce 1.90

Italian province update for nopCommerce 1.90 With  (region)


Current italy [CountryID] is 45 if is different replace it with the correct one
SQL Script:


INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Agrigento (Sicilia)','AG',1);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Alessandria (Piemonte)','AL',2);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Ancona (Marche)','AN',3);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Aosta (Valle d''Aosta)','AO',4);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Arezzo (Toscana)','AR',5);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Ascoli Piceno (Marche)','AP',6);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Asti (Piemonte)','AT',7);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Avellino (Campania)','AV',8);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Bari (Puglia)','BA',9);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Barletta-Andria-Trani (Puglia)','BT',10);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Belluno (Veneto)','BL',11);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Benevento (Campania)','BN',12);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Bergamo (Lombardia)','BG',13);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Biella (Piemonte)','BI',14);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Bologna (Emilia-Romagna)','BO',15);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Bolzano (Trentino-Alto Adige)','BZ',16);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Brescia (Lombardia)','BS',17);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Brindisi (Puglia)','BR',18);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Cagliari (Sardegna)','CA',19);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Caltanissetta (Sicilia)','CL',20);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Campobasso (Molise)','CB',21);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Carbonia-Iglesias (Sardegna)','CI',22);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Caserta (Campania)','CE',23);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Catania (Sicilia)','CT',24);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Catanzaro (Calabria)','CZ',25);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Chieti (Abruzzo)','CH',26);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Como (Lombardia)','CO',27);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Cosenza (Calabria)','CS',28);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Cremona (Lombardia)','CR',29);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Crotone (Calabria)','KR',30);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Cuneo (Piemonte)','CN',31);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Enna (Sicilia)','EN',31);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Fermo (Marche)','FM',33);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Ferrara (Emilia-Romagna)','FE',34);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Firenze (Toscana)','FI',35);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Foggia (Puglia)','FG',36);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Forlì-Cesena (Emilia-Romagna)','FC',37);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Frosinone (Lazio)','FR',38);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Genova (Liguria)','GE',39);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Gorizia (Friuli-Venezia Giulia)','GO',40);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Grosseto (Toscana)','GR',41);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Imperia (Liguria)','IM',42);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Isernia (Molise)','IS',43);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'La Spezia (Liguria)','SP',44);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'L''Aquila (Abruzzo)','AQ',45);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Latina (Lazio)','LT',46);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Lecce (Puglia)','LE',47);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Lecco (Lombardia)','LC',48);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Livorno (Toscana)','LI',49);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Lodi (Lombardia)','LO',50);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Lucca (Toscana)','LU',51);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Macerata (Marche)','MC',52);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Mantova (Lombardia)','MN',53);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Massa-Carrara (Toscana)','MS',54);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Matera (Basilicata)','MT',55);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Messina (Sicilia)','ME',56);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Milano (Lombardia)','MI',57);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Modena (Emilia-Romagna)','MO',58);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Monza e della Brianza (Lombardia)','MB',59);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Napoli (Campania)','NA',60);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Novara (Piemonte)','NO',61);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Nuoro (Sardegna)','NU',62);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Olbia-Tempio (Sardegna)','OT',63);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Oristano (Sardegna)','OR',64);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Padova (Veneto)','PD',65);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Palermo (Sicilia)','PA',66);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Parma (Emilia-Romagna)','PR',67);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Pavia (Lombardia)','PV',68);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Perugia (Umbria)','PG',69);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Pesaro e Urbino (Marche)','PU',70);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Pescara (Abruzzo)','PE',71);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Piacenza (Emilia-Romagna)','PC',72);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Pisa (Toscana)','PI',73);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Pistoia (Toscana)','PT',74);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Pordenone (Friuli-Venezia Giulia)','PN',75);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Potenza (Basilicata)','PZ',76);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Prato (Toscana)','PO',77);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Ragusa (Sicilia)','RG',78);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Ravenna (Emilia-Romagna)','RA',79);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Reggio Calabria (Calabria)','RC',80);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Reggio Emilia (Emilia-Romagna)','RE',81);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Rieti (Lazio)','RI',82);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Rimini (Emilia-Romagna)','RN',83);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Roma (Lazio)','RM',84);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Rovigo (Veneto)','RO',85);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Salerno (Campania)','SA',86);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Medio Campidano (Sardegna)','VS',87);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Sassari (Sardegna)','SS',88);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Savona (Liguria)','SV',89);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Siena (Toscana)','SI',90);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Siracusa (Sicilia)','SR',91);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Sondrio (Lombardia)','SO',92);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Taranto (Puglia)','TA',93);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Teramo (Abruzzo)','TE',94);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Terni (Umbria)','TR',95);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Torino (Piemonte)','TO',96);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Ogliastra (Sardegna)','OG',97);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Trapani (Sicilia)','TP',98);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Trento (Trentino-Alto Adige)','TN',99);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Treviso (Veneto)','TV',100);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Trieste (Friuli-Venezia Giulia)','TS',101);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Udine (Friuli-Venezia Giulia)','UD',102);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Varese (Lombardia)','VA',103);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Venezia (Veneto)','VE',104);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Verbano-Cusio-Ossola (Piemonte)','VB',105);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Vercelli (Piemonte)','VC',106);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Verona (Veneto)','VR',107);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Vibo Valentia (Calabria)','VV',108);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Vicenza (Veneto)','VI',109);

and without (region)

INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Agrigento','AG',1);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Alessandria','AL',2);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Ancona','AN',3);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Aosta','AO',4);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Arezzo','AR',5);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Ascoli Piceno','AP',6);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Asti','AT',7);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Avellino','AV',8);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Bari','BA',9);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Barletta-Andria-Trani','BT',10);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Belluno','BL',11);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Benevento','BN',12);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Bergamo','BG',13);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Biella','BI',14);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Bologna','BO',15);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Bolzano','BZ',16);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Brescia','BS',17);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Brindisi','BR',18);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Cagliari','CA',19);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Caltanissetta','CL',20);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Campobasso','CB',21);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Carbonia-Iglesias','CI',22);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Caserta','CE',23);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Catania','CT',24);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Catanzaro','CZ',25);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Chieti','CH',26);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Como','CO',27);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Cosenza','CS',28);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Cremona','CR',29);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Crotone','KR',30);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Cuneo','CN',31);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Enna','EN',31);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Fermo','FM',33);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Ferrara','FE',34);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Firenze','FI',35);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Foggia','FG',36);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Forlì-Cesena','FC',37);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Frosinone','FR',38);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Genova','GE',39);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Gorizia','GO',40);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Grosseto','GR',41);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Imperia','IM',42);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Isernia','IS',43);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'La Spezia','SP',44);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'L''Aquila','AQ',45);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Latina','LT',46);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Lecce','LE',47);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Lecco','LC',48);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Livorno','LI',49);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Lodi','LO',50);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Lucca','LU',51);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Macerata','MC',52);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Mantova','MN',53);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Massa-Carrara','MS',54);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Matera','MT',55);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Messina','ME',56);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Milano','MI',57);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Modena','MO',58);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Monza e della Brianza','MB',59);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Napoli','NA',60);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Novara','NO',61);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Nuoro','NU',62);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Olbia-Tempio','OT',63);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Oristano','OR',64);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Padova','PD',65);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Palermo','PA',66);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Parma','PR',67);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Pavia','PV',68);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Perugia','PG',69);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Pesaro e Urbino','PU',70);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Pescara','PE',71);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Piacenza','PC',72);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Pisa','PI',73);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Pistoia','PT',74);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Pordenone','PN',75);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Potenza','PZ',76);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Prato','PO',77);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Ragusa','RG',78);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Ravenna','RA',79);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Reggio Calabria','RC',80);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Reggio Emilia','RE',81);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Rieti','RI',82);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Rimini','RN',83);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Roma','RM',84);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Rovigo','RO',85);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Salerno','SA',86);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Medio Campidano','VS',87);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Sassari','SS',88);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Savona','SV',89);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Siena','SI',90);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Siracusa','SR',91);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Sondrio','SO',92);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Taranto','TA',93);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Teramo','TE',94);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Terni','TR',95);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Torino','TO',96);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Ogliastra','OG',97);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Trapani','TP',98);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Trento','TN',99);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Treviso','TV',100);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Trieste','TS',101);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Udine','UD',102);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Varese','VA',103);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Venezia','VE',104);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Verbano-Cusio-Ossola','VB',105);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Vercelli','VC',106);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Verona','VR',107);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Vibo Valentia','VV',108);
INSERT INTO [nopComm].[dbo].[Nop_StateProvince]([CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(45,'Vicenza','VI',109);

nopCommerce 2.30 :-)

INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Agrigento','AG',1);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Alessandria','AL',2);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Ancona','AN',3);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Aosta','AO',4);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Arezzo','AR',5);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Ascoli Piceno','AP',6);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Asti','AT',7);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Avellino','AV',8);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Bari','BA',9);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Barletta-Andria-Trani','BT',10);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Belluno','BL',11);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Benevento','BN',12);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Bergamo','BG',13);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Biella','BI',14);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Bologna','BO',15);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Bolzano','BZ',16);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Brescia','BS',17);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Brindisi','BR',18);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Cagliari','CA',19);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Caltanissetta','CL',20);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Campobasso','CB',21);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Carbonia-Iglesias','CI',22);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Caserta','CE',23);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Catania','CT',24);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Catanzaro','CZ',25);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Chieti','CH',26);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Como','CO',27);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Cosenza','CS',28);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Cremona','CR',29);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Crotone','KR',30);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Cuneo','CN',31);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Enna','EN',31);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Fermo','FM',33);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Ferrara','FE',34);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Firenze','FI',35);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Foggia','FG',36);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Forlì-Cesena','FC',37);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Frosinone','FR',38);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Genova','GE',39);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Gorizia','GO',40);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Grosseto','GR',41);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Imperia','IM',42);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Isernia','IS',43);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'La Spezia','SP',44);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'L''Aquila','AQ',45);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Latina','LT',46);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Lecce','LE',47);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Lecco','LC',48);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Livorno','LI',49);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Lodi','LO',50);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Lucca','LU',51);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Macerata','MC',52);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Mantova','MN',53);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Massa-Carrara','MS',54);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Matera','MT',55);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Messina','ME',56);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Milano','MI',57);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Modena','MO',58);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Monza e della Brianza','MB',59);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Napoli','NA',60);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Novara','NO',61);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Nuoro','NU',62);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Olbia-Tempio','OT',63);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Oristano','OR',64);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Padova','PD',65);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Palermo','PA',66);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Parma','PR',67);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Pavia','PV',68);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Perugia','PG',69);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Pesaro e Urbino','PU',70);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Pescara','PE',71);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Piacenza','PC',72);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Pisa','PI',73);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Pistoia','PT',74);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Pordenone','PN',75);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Potenza','PZ',76);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Prato','PO',77);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Ragusa','RG',78);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Ravenna','RA',79);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Reggio Calabria','RC',80);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Reggio Emilia','RE',81);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Rieti','RI',82);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Rimini','RN',83);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Roma','RM',84);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Rovigo','RO',85);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Salerno','SA',86);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Medio Campidano','VS',87);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Sassari','SS',88);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Savona','SV',89);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Siena','SI',90);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Siracusa','SR',91);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Sondrio','SO',92);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Taranto','TA',93);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Teramo','TE',94);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Terni','TR',95);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Torino','TO',96);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Ogliastra','OG',97);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Trapani','TP',98);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Trento','TN',99);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Treviso','TV',100);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Trieste','TS',101);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Udine','UD',102);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Varese','VA',103);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Venezia','VE',104);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Verbano-Cusio-Ossola','VB',105);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Vercelli','VC',106);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Verona','VR',107);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Vibo Valentia','VV',108);
INSERT INTO [dbo].[StateProvince](Published,[CountryID],[Name],[Abbreviation],[DisplayOrder])
     VALUES(1,45,'Vicenza','VI',109);

Cool,
I'll check it for new changes, but thanks so far.
Francesco