Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE DATABASE Groceries;
- USE Groceries;
- GO;
- CREATE TABLE Product (
- id INT PRIMARY KEY IDENTITY(1,1),
- name VARCHAR(50) NOT NULL,
- price DECIMAL NOT NULL
- );
- USE Groceries;
- GO;
- CREATE TABLE Grocery (
- id INT PRIMARY KEY IDENTITY(1,1),
- montant DECIMAL NOT NULL,
- DATE DATETIME NOT NULL
- );
- GO;
- INSERT INTO Product (name, price)
- VALUES ('Tomato', 24);
- INSERT INTO Product (name, price)
- VALUES ('Apple', 30);
- INSERT INTO Product (name, price)
- VALUES ('Brocolis', 100);
- INSERT INTO Grocery (montant, DATE)
- VALUES ('1098', '2000-04-08 10:30:00');
- INSERT INTO Grocery (montant, DATE)
- VALUES ('345.45', '1987-02-12 13:45:02');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
