parent nodes: InsertarSQL | SQLapuntes
Hay dos formas de insertar filas en una tabla, dando los valores o dando una subconsulta
Use a VALUES clause to specify the data values for one row:
INSERT INTO MyTable (PriKey, Description)
VALUES (123, 'A description of part 123.')
Use a SELECT subquery to specify the data values for one or more rows:
INSERT INTO MyTable (PriKey, Description)
SELECT ForeignKey, Description
FROM SomeView