diff options
| author | Andrew <saintruler@gmail.com> | 2021-12-17 08:19:30 +0400 |
|---|---|---|
| committer | Andrew <saintruler@gmail.com> | 2021-12-17 08:19:30 +0400 |
| commit | 15860fa29285ce48959f980dd44027f683f28b66 (patch) | |
| tree | 5100c4bd4436799ce03e6675181a12a82c870a9a /task6_triggers.sql | |
| parent | 9bd4a687c64c31dbed810e65297601d0233242f2 (diff) | |
Исправил шестую и седьмую лабы
Diffstat (limited to 'task6_triggers.sql')
| -rw-r--r-- | task6_triggers.sql | 18 |
1 files changed, 0 insertions, 18 deletions
diff --git a/task6_triggers.sql b/task6_triggers.sql index 67c79e3..3275880 100644 --- a/task6_triggers.sql +++ b/task6_triggers.sql @@ -63,24 +63,6 @@ GO DELETE FROM Deliveries WHERE driver_id=2 GO --- Add - -INSERT INTO Drivers (city_id, salary, on_delivery) -VALUES (4, 35000, 0); -GO - -INSERT INTO Vehicles (name, tonnage, gas_consumption) -VALUES (N'KAMAZ', 30, 50); -GO - -INSERT INTO Routes (city1_id, city2_id, distance) -VALUES (1, 2, 900); -GO - -INSERT INTO Deliveries (driver_id, vehicle_id, route_id, date) -VALUES (1, 1, 1, '2021-09-08'); -GO - --------------- -- Задание 2 -- --------------- |