diff options
Diffstat (limited to 'task5_views.sql')
| -rw-r--r-- | task5_views.sql | 4 |
1 files changed, 3 insertions, 1 deletions
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 |