From e8a09723e64eec1c0baf34878d58d0bbaa21b9f7 Mon Sep 17 00:00:00 2001 From: Andrew Guschin Date: Sun, 26 Jun 2022 11:19:56 +0400 Subject: =?UTF-8?q?=D0=94=D0=BE=D0=BF=D0=BE=D0=BB=D0=BD=D0=B8=D0=BB=20.git?= =?UTF-8?q?ignore?= MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- task5_views.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'task5_views.sql') diff --git a/task5_views.sql b/task5_views.sql index 145380e..d3ce6a5 100644 --- a/task5_views.sql +++ b/task5_views.sql @@ -1,3 +1,5 @@ +USE shipping + --------------- -- Задание 1 -- --------------- @@ -57,7 +59,7 @@ GO --------------- CREATE VIEW BoxesView AS -SELECT * FROM Boxes +SELECT * FROM shipping.dbo.Boxes WHERE weight < 25 AND volume <= 1.1 WITH CHECK OPTION GO -- cgit v1.2.3