Advertisement
Guest User

Untitled

a guest
Jul 2nd, 2015
247
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 2.49 KB | None | 0 0
  1. INSERT INTO Kupac (Ime, Prezime, OIB, Grad, Ulica, KucniBroj, Email, Telefon, SpolId)
  2. VALUES ('Pero', 'Peric', '12345678912', 'Zagreb', 'Ilica', 12, 'pero@mail.com', '011231234', (SELECT Spol.IdSpol FROM Spol WHERE Spol.Naziv = 'Muski'))
  3. GO  
  4.  
  5. INSERT INTO Kupac (Ime, Prezime, OIB, Grad, Ulica, KucniBroj, Email, Telefon, SpolId)
  6. VALUES ('Jura', 'Juric', '45987123658', 'Zagreb', 'Vukovarska', 22, 'jura@mail.com', '018971235', (SELECT Spol.IdSpol FROM Spol WHERE Spol.Naziv = 'Muski'))
  7. GO  
  8.  
  9. INSERT INTO Kupac (Ime, Prezime, OIB, Grad, Ulica, KucniBroj, Email, Telefon, SpolId)
  10. VALUES ('Ivo', 'Ivic', '33265554711', 'Rijeka', 'Bastijanova', 5, 'ivo@mail.com', '0914741111', (SELECT Spol.IdSpol FROM Spol WHERE Spol.Naziv = 'Muski'))
  11. GO  
  12.  
  13. INSERT INTO Kupac (Ime, Prezime, OIB, Grad, Ulica, KucniBroj, Email, Telefon, SpolId)
  14. VALUES ('Ana', 'Anic', '55544421374', 'Rijeka', 'Vukovarska', 18, 'ana@mail.com', '0913332112', (SELECT Spol.IdSpol FROM Spol WHERE Spol.Naziv = 'Zenski'))
  15. GO  
  16.  
  17. INSERT INTO Kupac (Ime, Prezime, OIB, Grad, Ulica, KucniBroj, Email, Telefon, SpolId)
  18. VALUES ('Maja', 'Majic', '98947414023', 'Osijek', 'Drinska', 9, 'maja@mail.com', '0988415555', (SELECT Spol.IdSpol FROM Spol WHERE Spol.Naziv = 'Zenski'))
  19. GO  
  20.  
  21. INSERT INTO Kupac (Ime, Prezime, OIB, Grad, Ulica, KucniBroj, Email, Telefon, SpolId)
  22. VALUES ('Zdravko', 'Zdravkic', '20159873641', 'Osijek', 'Vinogradska', 26, 'zdravko@mail.com', '0988415555', (SELECT Spol.IdSpol FROM Spol WHERE Spol.Naziv = 'Muski'))
  23. GO  
  24.  
  25. INSERT INTO Kupac (Ime, Prezime, OIB, Grad, Ulica, KucniBroj, Email, Telefon, SpolId)
  26. VALUES ('Petra', 'Petric', '97859110245', 'Varazdin', 'Jalkovecka', 33, 'petra@mail.com', '0987114121', (SELECT Spol.IdSpol FROM Spol WHERE Spol.Naziv = 'Zenski'))
  27. GO  
  28.  
  29. INSERT INTO Kupac (Ime, Prezime, OIB, Grad, Ulica, KucniBroj, Email, Telefon, SpolId)
  30. VALUES ('Marko', 'Markic', '99510802457', 'Varazdin', 'Gospodarska', 3, 'marko@mail.com', '0917411471', (SELECT Spol.IdSpol FROM Spol WHERE Spol.Naziv = 'Muski'))
  31. GO  
  32.  
  33. INSERT INTO Kupac (Ime, Prezime, OIB, Grad, Ulica, KucniBroj, Email, Telefon, SpolId)
  34. VALUES ('Sanja', 'Sanjic', '92354120582', 'Zadar', 'Splitska', 10, 'sanja@mail.com', '0981230087', (SELECT Spol.IdSpol FROM Spol WHERE Spol.Naziv = 'Zenski'))
  35. GO
  36.  
  37. INSERT INTO Kupac (Ime, Prezime, OIB, Grad, Ulica, KucniBroj, Email, Telefon, SpolId)
  38. VALUES ('Marija', 'Maric', '17645890245', 'Zadar', 'Zagrebacka', 21, 'marija@mail.com', '0912003265', (SELECT Spol.IdSpol FROM Spol WHERE Spol.Naziv = 'Zenski'))
  39. GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement