Created
May 16, 2025 13:59
-
-
Save Giovasdf/d443b34f22692d4d7ef8dc804f63eb3e to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| USE somosoppa; | |
| -- Insertar Región Metropolitana | |
| INSERT INTO dbo.Region (id, nombre) | |
| VALUES ('00000000-0000-0000-0000-000000000013', 'Región Metropolitana'); | |
| -- Variables con los ID fijos de las provincias | |
| DECLARE @RegionId UNIQUEIDENTIFIER = '00000000-0000-0000-0000-000000000013'; | |
| DECLARE @ProvSantiago UNIQUEIDENTIFIER = '3EE107D4-CFBC-40B3-8221-66EB9603DAF4'; | |
| DECLARE @ProvChacabuco UNIQUEIDENTIFIER = '69C2F663-DB24-4FC5-9AD1-3592F0F52367'; | |
| DECLARE @ProvCordillera UNIQUEIDENTIFIER = '83BDF93B-0D16-4108-BEBE-2385444A8DAE'; | |
| DECLARE @ProvMaipo UNIQUEIDENTIFIER = '4F4A34B0-BF57-4060-BB48-B00799867E82'; | |
| DECLARE @ProvMelipilla UNIQUEIDENTIFIER = '9DA3D746-57FB-4A3E-A206-11C4A7911138'; | |
| DECLARE @ProvTalagante UNIQUEIDENTIFIER = 'B4B1F0BF-4FD1-4151-9038-849B7CD62961'; | |
| -- Insertar provincias | |
| INSERT INTO dbo.Provincia (id, nombre, idRegion) VALUES | |
| (@ProvSantiago, 'Santiago', @RegionId), | |
| (@ProvChacabuco, 'Chacabuco', @RegionId), | |
| (@ProvCordillera, 'Cordillera', @RegionId), | |
| (@ProvMaipo, 'Maipo', @RegionId), | |
| (@ProvMelipilla, 'Melipilla', @RegionId), | |
| (@ProvTalagante, 'Talagante', @RegionId); | |
| -- ============================= | |
| -- Comunas por provincia | |
| -- ============================= | |
| -- Santiago | |
| INSERT INTO dbo.Comuna (id, nombre, idProvincia) VALUES | |
| (NEWID(), 'Cerrillos', @ProvSantiago), | |
| (NEWID(), 'Cerro Navia', @ProvSantiago), | |
| (NEWID(), 'Conchalí', @ProvSantiago), | |
| (NEWID(), 'El Bosque', @ProvSantiago), | |
| (NEWID(), 'Estación Central', @ProvSantiago), | |
| (NEWID(), 'Huechuraba', @ProvSantiago), | |
| (NEWID(), 'Independencia', @ProvSantiago), | |
| (NEWID(), 'La Cisterna', @ProvSantiago), | |
| (NEWID(), 'La Florida', @ProvSantiago), | |
| (NEWID(), 'La Granja', @ProvSantiago), | |
| (NEWID(), 'La Pintana', @ProvSantiago), | |
| (NEWID(), 'La Reina', @ProvSantiago), | |
| (NEWID(), 'Las Condes', @ProvSantiago), | |
| (NEWID(), 'Lo Barnechea', @ProvSantiago), | |
| (NEWID(), 'Lo Espejo', @ProvSantiago), | |
| (NEWID(), 'Lo Prado', @ProvSantiago), | |
| (NEWID(), 'Macul', @ProvSantiago), | |
| (NEWID(), 'Maipú', @ProvSantiago), | |
| (NEWID(), 'Ñuñoa', @ProvSantiago), | |
| (NEWID(), 'Pedro Aguirre Cerda', @ProvSantiago), | |
| (NEWID(), 'Peñalolén', @ProvSantiago), | |
| (NEWID(), 'Providencia', @ProvSantiago), | |
| (NEWID(), 'Pudahuel', @ProvSantiago), | |
| (NEWID(), 'Quilicura', @ProvSantiago), | |
| (NEWID(), 'Quinta Normal', @ProvSantiago), | |
| (NEWID(), 'Recoleta', @ProvSantiago), | |
| (NEWID(), 'Renca', @ProvSantiago), | |
| (NEWID(), 'San Joaquín', @ProvSantiago), | |
| (NEWID(), 'San Miguel', @ProvSantiago), | |
| (NEWID(), 'San Ramón', @ProvSantiago), | |
| (NEWID(), 'Santiago', @ProvSantiago), | |
| (NEWID(), 'Vitacura', @ProvSantiago); | |
| -- Chacabuco | |
| INSERT INTO dbo.Comuna (id, nombre, idProvincia) VALUES | |
| (NEWID(), 'Colina', @ProvChacabuco), | |
| (NEWID(), 'Lampa', @ProvChacabuco), | |
| (NEWID(), 'Tiltil', @ProvChacabuco); | |
| -- Cordillera | |
| INSERT INTO dbo.Comuna (id, nombre, idProvincia) VALUES | |
| (NEWID(), 'Puente Alto', @ProvCordillera), | |
| (NEWID(), 'Pirque', @ProvCordillera), | |
| (NEWID(), 'San José de Maipo', @ProvCordillera); | |
| -- Maipo | |
| INSERT INTO dbo.Comuna (id, nombre, idProvincia) VALUES | |
| (NEWID(), 'San Bernardo', @ProvMaipo), | |
| (NEWID(), 'Buin', @ProvMaipo), | |
| (NEWID(), 'Paine', @ProvMaipo), | |
| (NEWID(), 'Calera de Tango', @ProvMaipo); | |
| -- Melipilla | |
| INSERT INTO dbo.Comuna (id, nombre, idProvincia) VALUES | |
| (NEWID(), 'Melipilla', @ProvMelipilla), | |
| (NEWID(), 'Alhué', @ProvMelipilla), | |
| (NEWID(), 'Curacaví', @ProvMelipilla), | |
| (NEWID(), 'María Pinto', @ProvMelipilla), | |
| (NEWID(), 'San Pedro', @ProvMelipilla); | |
| -- Talagante | |
| INSERT INTO dbo.Comuna (id, nombre, idProvincia) VALUES | |
| (NEWID(), 'Talagante', @ProvTalagante), | |
| (NEWID(), 'El Monte', @ProvTalagante), | |
| (NEWID(), 'Isla de Maipo', @ProvTalagante), | |
| (NEWID(), 'Padre Hurtado', @ProvTalagante), | |
| (NEWID(), 'Peñaflor', @ProvTalagante); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment