diff options
| author | Andrew Guschin <guschin.drew@gmail.com> | 2022-06-26 11:19:56 +0400 |
|---|---|---|
| committer | Andrew Guschin <guschin.drew@gmail.com> | 2022-06-26 11:19:56 +0400 |
| commit | e8a09723e64eec1c0baf34878d58d0bbaa21b9f7 (patch) | |
| tree | b961d072a6a918d23aecdb43d6712bebb65d19f0 | |
| parent | f0dc98b93c12e6428d84533bc4cc42210522548f (diff) | |
Дополнил .gitignore
| -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 |