Herramienta de Comparación de Queries SQL con UNION
1. Query de Entrada
SELECT o.OrderID, o.OrderDate, (SELECT SUM(od.Quantity * od.UnitPrice) FROM OrderDetails_A od WHERE od.OrderID = o.OrderID) AS TotalAmount, c.CompanyName AS Customer, (SELECT COUNT(*) FROM Shipments_A sh WHERE sh.OrderID = o.OrderID) AS ShipmentCount, o.Notes AS OrderNotes FROM Orders_A o JOIN Customers_A c ON o.CustomerID = c.CustomerID WHERE o.Country = 'ES' UNION ALL SELECT s.SaleID AS OrderID, s.TransactionDate AS OrderDate, (SELECT SUM(li.Units * li.Cost) FROM LineItems_B li WHERE li.SaleID = s.SaleID) AS TotalAmount, b.BuyerName AS Customer, (SELECT COUNT(*) FROM Deliveries_B d WHERE d.SaleID = s.SaleID) AS ShipmentCount, s.SaleDescription AS OrderNotes FROM Sales_B s JOIN Buyers_B b ON s.BuyerID = b.BuyerID WHERE s.Region = 'EU-South' ORDER BY OrderID;
Copiar Entrada
Pegar Entrada
Analizar Query
Borrar Query Entrada
2. Seleccione Campos Clave
Analice una query para ver los campos.
3. Seleccione Campos a Comparar (todos por defecto)
Analice una query para ver los campos.
Comparar campos sensibles (ntext, text, image) como NVARCHAR(MAX)
Generar Query de Diferencias
4. Query de Diferencias Generada
Copiar Resultado