Sql Consulta De Accion

CLASE DE RELACIONAR TABLAS

CLIENTES

SELECT CustomerID AS NCliente, CompanyName AS NomCia, ContactName AS NomCont, ContactTitle AS CargoCont, Address AS Direccion, City AS Ciudad,PostalCode AS CodPostal, Region, Country AS Pais, Phone AS Telefono, Fax
INTO Clientes
FROM Customers
WHERE (CustomerID N'VICTE')


PEDIDOS

SELECTOrderID AS NPedido, CustomerID AS NCliente, EmployeeID AS NEmpleado, OrderDate AS FechaPedido, RequiredDate AS FechaRequerida,
ShippedDate AS FechaEnvio, ShipVia AS ViaEnvio,Freight AS Cargo, ShipName AS Destinatario, ShipAddress AS DireccionEnvio, ShipCity AS CiudadEnvio,
ShipRegion AS RegionEnvio, ShipPostalCode AS CodPostalEnvio, ShipCountry ASPaisEnvio
INTO Pedidos
FROM Orders
WHERE (CustomerID N'VICTE')



DPEDIDOS

SELECT [Order Details].OrderID AS NPedido, [Order Details].ProductID AS NProducto, [OrderDetails].UnitPrice AS PrecioUnit, [Order Details].Quantity AS Cantidad,
[Order Details].Discount AS Descuento
INTO DPedido
FROM [Order Details] INNER JOINOrders ON [Order Details].OrderID = Orders.OrderID
WHERE (Orders.CustomerID N'VICTE')


HAY Q ELIMINAR EL CLIENTE VICTE DE TODAS LAS TABLAS
LUEGO AGREGAMOS LAS LLAVESPRINCIPALES A LAS RESPECTIVAS TABLAS

PEDIDOS: NPEDIDO
CLIENTES: NCLIENTE
DPEDIDO: NPEDIDO Y NPRODUCTO

LUEGO ARRASTRAMOS LAS LLAVES PARA RELACIONALAS Y LISTO


CONSULTAAAAAAAAAASACTUALIZAR PAIS BRAZIL A COLOMBIA

UPDATE Clientes
SET Pais = N'Colombia'
WHERE (Pais = N'Brazil')




ELIMINAR LOS CLIENTES DE USA


INTEGRIDAD DIFERENCIAL ENTRE LAS 3TABLAS

NO PUEDO ELIMINARLOS XQ HAY PEDIDOS DE CLIENTES QUE SON DEL PAIS USA, EN ESE CASO TENDRIA QUE ELIMINAR TODOS LOS
PEDIDOS DE ESE PAIS.



INGRESAR UN CLIENTE NUEVO QUE SERA DE CHILE...