diff options
| -rw-r--r-- | task6_triggers.sql | 4 | ||||
| -rw-r--r-- | task7_procedures.sql | 4 |
2 files changed, 4 insertions, 4 deletions
diff --git a/task6_triggers.sql b/task6_triggers.sql index 3275880..20b1e6e 100644 --- a/task6_triggers.sql +++ b/task6_triggers.sql @@ -52,7 +52,7 @@ DROP TRIGGER RemoveDriverOnDelivery GO INSERT INTO Deliveries (driver_id, vehicle_id, route_id, date) -VALUES (1, 1, 1, '2021-09-08') +VALUES (1, 1, 1, '2021-04-15') GO UPDATE Deliveries @@ -154,7 +154,7 @@ DROP TRIGGER UpdateOrdersView GO UPDATE OrdersView -SET driver_id=2 +SET driver_id=1 WHERE order_date='2021-09-12' GO diff --git a/task7_procedures.sql b/task7_procedures.sql index 891db18..f3d7e84 100644 --- a/task7_procedures.sql +++ b/task7_procedures.sql @@ -41,10 +41,10 @@ DROP PROCEDURE calculate_order_price GO INSERT INTO Boxes (order_id, warehouse_id, wrapping_id, volume, weight) -VALUES (100020, 1, 1, 0.1, 10); +VALUES (100022, 1, 1, 0.1, 10); DECLARE @price INT; -EXEC calculate_order_price 100020, @price OUTPUT; +EXEC calculate_order_price 100022, @price OUTPUT; PRINT @price GO |