Skip to content

Instantly share code, notes, and snippets.

@marquinhosoliveira

marquinhosoliveira/Insert Into Tables.SQL

Last active April 14, 2019 16:02
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save marquinhosoliveira/2605b40c8ff9370699eab1a5a35a31be to your computer and use it in GitHub Desktop.
Save marquinhosoliveira/2605b40c8ff9370699eab1a5a35a31be to your computer and use it in GitHub Desktop.
Download ZIP
Populando as tabelas PAI MAE E FILHOS
Raw
Insert Into Tables.SQL
INSERT INTO HOMEM (IDHOMEM, NMHOMEM) VALUES (1,'JOSE')
INSERT INTO HOMEM (IDHOMEM, NMHOMEM) VALUES (2,'JOAO')
INSERT INTO HOMEM (IDHOMEM, NMHOMEM) VALUES (3,'MANOEL')
INSERT INTO HOMEM (IDHOMEM, NMHOMEM) VALUES (4,'SEBASTIAO')
GO
INSERT INTO MULHER (IDMULHER, NMMULHER) VALUES (1,'MARIA')
INSERT INTO MULHER (IDMULHER, NMMULHER) VALUES (2,'MARCIA')
INSERT INTO MULHER (IDMULHER, NMMULHER) VALUES (3,'ANA')
INSERT INTO MULHER (IDMULHER, NMMULHER) VALUES (4,'LAURA')
GO
INSERT INTO FILHO (IDFILHO , NMFILHO, IDHOMEM, IDMULHER ) VALUES (1,'PEDRO',1,1)
INSERT INTO FILHO (IDFILHO , NMFILHO, IDHOMEM, IDMULHER ) VALUES (2,'MANUELA',2,2)
INSERT INTO FILHO (IDFILHO , NMFILHO, IDHOMEM, IDMULHER ) VALUES (3,'ANTONIO',NULL,3)
INSERT INTO FILHO (IDFILHO , NMFILHO, IDHOMEM, IDMULHER ) VALUES (3,'CARLA',1,NULL)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment