Script.sql
--выбор базы USE zzz GO --создание таблицы CREATE TABLE Book ( IDBook INT NOT NULL PRIMARY KEY IDENTITY(1, 1), Name NVARCHAR(50) NOT NULL, Amount INT NOT NULL, Price MONEY NOT NULL ) --вставка данных INSERT INTO Book(Name, Amount, Price) VALUES (N'Азбука', 10, 10.15), (N'Букварь', 20, 20.25), (N'Физика', 30, 30.35), (N'Математика', 40, 40.45), (N'География', 50, 50.55) --вывод данных SELECT Name, Amount, Price FROM Book WHERE Amount NOT BETWEEN 20 AND 40
--выбор базы USE zzz GO --создание таблицы CREATE TABLE Book ( IDBook INT NOT NULL PRIMARY KEY IDENTITY(1, 1), Name NVARCHAR(50) NOT NULL, Amount INT NOT NULL, Price MONEY NOT NULL ) --вставка данных INSERT INTO Book(Name, Amount, Price) VALUES (N'Азбука', 10, 10.15), (N'Букварь', 20, 20.25), (N'Физика', 30, 30.35), (N'Математика', 40, 40.45), (N'География', 50, 50.55) --вывод данных SELECT Name, Amount, Price FROM Book WHERE Amount NOT BETWEEN 20 AND 40