Advertisement
Rayne_47

mssql create insert

Feb 23rd, 2015
212
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.48 KB | None | 0 0
  1. USE Test2
  2.  
  3. CREATE TABLE Stolowka
  4. (
  5. ID INT  IDENTITY(1,1) PRIMARY KEY,
  6. Potrawa VARCHAR(50) NOT NULL
  7. );
  8.  
  9. CREATE TABLE Student
  10. (
  11. ID INT  IDENTITY(1,1) PRIMARY KEY,
  12. ID_stolowki INT NOT NULL REFERENCES Stolowka(ID),
  13. Imie VARCHAR(50),
  14. Nazwisko VARCHAR(50)
  15. );
  16.  
  17. INSERT INTO Stolowka
  18. VALUES ('Zupka z Siana'), ('Ziemniaczki'), ('Kurczak');
  19.  
  20. INSERT INTO Student (ID_stolowki, Imie, Nazwisko)
  21. VALUES (1, 'Andrzej', 'Lis'), (2, 'Krystyna', 'z Gazowni'), (3, 'Misiek', 'LinkinPark');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement