Добавил запросы для создания процедур седьмой лабы.

1 files changed, 18 insertions, 0 deletions

diff --git a/task6_triggers.sql b/task6_triggers.sql
index 1c1a5f6..c6519d8 100644
--- a/task6_triggers.sql
+++ b/task6_triggers.sql
@@ -63,6 +63,24 @@ 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 --
 ---------------