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