Why i cant insert thinks into the tables this is my code
Why i cant insert thinks into the tables this is my code
CREATE TABLE employees (
id int identity not null ,
EmpFirstName nvarchar(255),
EmplastName nvarchar(255),
PRIMARY KEY (id),
);
CREATE TABLE suppliers (
id integer NOT NULL,
CompanyName varchar(50),
CompanyAddress varchar(255),
CompanyPhone bigint not null,
PRIMARY KEY (id),
);
CREATE TABLE products (
id integer NOT NULL,
ProductName varchar(50),
Productprice integer,
SupplierID integer NOT NULL,
PRIMARY KEY (id),
FOREIGN KEY (SupplierID) REFERENCES suppliers(id)
);
CREATE TABLE orders (
EmployeeId integer NOT NULL,
ProductId integer NOT NULL,
OrderDate date,
PRIMARY KEY (OrderDate),
FOREIGN KEY (EmployeeId) REFERENCES employees(id),
FOREIGN KEY (ProductId) REFERENCES products(id)
);
INSERT INTO employees(EmpFirstName,EmpLastName,EmployeeAddress)
VALUES ('Иван','Иванов','Хаджи Димитър 25'),
('Милена','Димитрова','Панайот Хитов 3'),
('Миглена','Панайотова', 'Васил Априлов' ),
('Васил','Трайков','Иван Вазов бл 4'),
('Димитринка', 'Станчева','Стефан Стамболов');
Step by step
Solved in 5 steps with 1 images
