diff options
| -rw-r--r-- | .gitignore | 3 | ||||
| -rw-r--r-- | task5_views.sql | 4 |
2 files changed, 5 insertions, 2 deletions
@@ -13,4 +13,5 @@ go.sum *.bbl *.blg *.bcf -*.xml
\ No newline at end of file +*.xml +.DS_Store 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 |