For those who want to add State/Province from Portugal:
INSERT [dbo].[Nop_StateProvince] ([StateProvinceID], [CountryID], [Name], [Abbreviation], [DisplayOrder]) VALUES (217, 62, N'Aveiro', N'AVR', 1)
INSERT [dbo].[Nop_StateProvince] ([StateProvinceID], [CountryID], [Name], [Abbreviation], [DisplayOrder]) VALUES (218, 62, N'Beja', N'BEJ', 2)
INSERT [dbo].[Nop_StateProvince] ([StateProvinceID], [CountryID], [Name], [Abbreviation], [DisplayOrder]) VALUES (219, 62, N'Braga', N'BRG', 3)
INSERT [dbo].[Nop_StateProvince] ([StateProvinceID], [CountryID], [Name], [Abbreviation], [DisplayOrder]) VALUES (220, 62, N'Bragança', N'BRC', 4)
INSERT [dbo].[Nop_StateProvince] ([StateProvinceID], [CountryID], [Name], [Abbreviation], [DisplayOrder]) VALUES (221, 62, N'Castelo Branco', N'CTB', 5)
INSERT [dbo].[Nop_StateProvince] ([StateProvinceID], [CountryID], [Name], [Abbreviation], [DisplayOrder]) VALUES (222, 62, N'Coimbra', N'COI', 6)
INSERT [dbo].[Nop_StateProvince] ([StateProvinceID], [CountryID], [Name], [Abbreviation], [DisplayOrder]) VALUES (223, 62, N'Évora', N'EVO', 7)
INSERT [dbo].[Nop_StateProvince] ([StateProvinceID], [CountryID], [Name], [Abbreviation], [DisplayOrder]) VALUES (224, 62, N'Faro', N'FAR', 8)
INSERT [dbo].[Nop_StateProvince] ([StateProvinceID], [CountryID], [Name], [Abbreviation], [DisplayOrder]) VALUES (225, 62, N'Guarda', N'GUA', 9)
INSERT [dbo].[Nop_StateProvince] ([StateProvinceID], [CountryID], [Name], [Abbreviation], [DisplayOrder]) VALUES (226, 62, N'Leiria', N'LEI', 10)
INSERT [dbo].[Nop_StateProvince] ([StateProvinceID], [CountryID], [Name], [Abbreviation], [DisplayOrder]) VALUES (227, 62, N'Lisboa', N'LSB', 11)
INSERT [dbo].[Nop_StateProvince] ([StateProvinceID], [CountryID], [Name], [Abbreviation], [DisplayOrder]) VALUES (228, 62, N'Portalegre', N'PTG', 12)
INSERT [dbo].[Nop_StateProvince] ([StateProvinceID], [CountryID], [Name], [Abbreviation], [DisplayOrder]) VALUES (229, 62, N'Porto', N'POR', 13)
INSERT [dbo].[Nop_StateProvince] ([StateProvinceID], [CountryID], [Name], [Abbreviation], [DisplayOrder]) VALUES (230, 62, N'Santarém', N'SAN', 14)
INSERT [dbo].[Nop_StateProvince] ([StateProvinceID], [CountryID], [Name], [Abbreviation], [DisplayOrder]) VALUES (231, 62, N'Setúbal', N'STB', 15)
INSERT [dbo].[Nop_StateProvince] ([StateProvinceID], [CountryID], [Name], [Abbreviation], [DisplayOrder]) VALUES (232, 62, N'Viana do Castelo', N'VNC', 16)
INSERT [dbo].[Nop_StateProvince] ([StateProvinceID], [CountryID], [Name], [Abbreviation], [DisplayOrder]) VALUES (233, 62, N'Vila Real', N'VLR', 17)
INSERT [dbo].[Nop_StateProvince] ([StateProvinceID], [CountryID], [Name], [Abbreviation], [DisplayOrder]) VALUES (234, 62, N'Viseu', N'VIS', 18)
INSERT [dbo].[Nop_StateProvince] ([StateProvinceID], [CountryID], [Name], [Abbreviation], [DisplayOrder]) VALUES (235, 62, N'Ilha da Madeira', N'IMD', 19)
INSERT [dbo].[Nop_StateProvince] ([StateProvinceID], [CountryID], [Name], [Abbreviation], [DisplayOrder]) VALUES (236, 62, N'Ilha de Porto Santo', N'IPS', 20)
INSERT [dbo].[Nop_StateProvince] ([StateProvinceID], [CountryID], [Name], [Abbreviation], [DisplayOrder]) VALUES (237, 62, N'Ilha de Santa Maria', N'ISM', 21)
INSERT [dbo].[Nop_StateProvince] ([StateProvinceID], [CountryID], [Name], [Abbreviation], [DisplayOrder]) VALUES (238, 62, N'Ilha de São Miguel', N'IMG', 22)
INSERT [dbo].[Nop_StateProvince] ([StateProvinceID], [CountryID], [Name], [Abbreviation], [DisplayOrder]) VALUES (239, 62, N'Ilha Terceira', N'ITC', 23)
INSERT [dbo].[Nop_StateProvince] ([StateProvinceID], [CountryID], [Name], [Abbreviation], [DisplayOrder]) VALUES (240, 62, N'Ilha da Graciosa', N'IGC', 24)
INSERT [dbo].[Nop_StateProvince] ([StateProvinceID], [CountryID], [Name], [Abbreviation], [DisplayOrder]) VALUES (241, 62, N'Ilha de São Jorge', N'ISJ', 25)
INSERT [dbo].[Nop_StateProvince] ([StateProvinceID], [CountryID], [Name], [Abbreviation], [DisplayOrder]) VALUES (242, 62, N'Ilha do Pico', N'IPC', 26)
INSERT [dbo].[Nop_StateProvince] ([StateProvinceID], [CountryID], [Name], [Abbreviation], [DisplayOrder]) VALUES (244, 62, N'Ilha do Faial', N'IFA', 27)
INSERT [dbo].[Nop_StateProvince] ([StateProvinceID], [CountryID], [Name], [Abbreviation], [DisplayOrder]) VALUES (245, 62, N'Ilha das Flores', N'IFL', 28)
INSERT [dbo].[Nop_StateProvince] ([StateProvinceID], [CountryID], [Name], [Abbreviation], [DisplayOrder]) VALUES (246, 62, N'Ilha do Corvo', N'ICV', 29)