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 /task5_views.sql | |
| parent | f0dc98b93c12e6428d84533bc4cc42210522548f (diff) | |
Дополнил .gitignore
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 |