Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE Test2
- CREATE TABLE Stolowka
- (
- ID INT IDENTITY(1,1) PRIMARY KEY,
- Potrawa VARCHAR(50) NOT NULL
- );
- CREATE TABLE Student
- (
- ID INT IDENTITY(1,1) PRIMARY KEY,
- ID_stolowki INT NOT NULL REFERENCES Stolowka(ID),
- Imie VARCHAR(50),
- Nazwisko VARCHAR(50)
- );
- INSERT INTO Stolowka
- VALUES ('Zupka z Siana'), ('Ziemniaczki'), ('Kurczak');
- INSERT INTO Student (ID_stolowki, Imie, Nazwisko)
- VALUES (1, 'Andrzej', 'Lis'), (2, 'Krystyna', 'z Gazowni'), (3, 'Misiek', 'LinkinPark');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement