Created by Carlos Navarro
over 6 years ago
|
||
Question | Answer |
Sentencia INSERT
Image:
Logo Azure Sql (image/png)
|
INSERT: Agrega filas en una tabla. Unica sentencia que provee SQL para agregar filas. Existen 2 Formas de ejecutar el insert 1) Usando la cláusula VALUES (agrega una sola fila por cada comando insert) INSERT INTO table [(column [, column...])] VALUES (value [, value...]); INSERT INTO empleados VALUES (1, ‘Juan Perez’, ‘04/04/98’, 100) INSERT INTO deptos (dcod, ddescr) VALUES (50, ‘CONTABILIDAD') INSERT INTO deptos VALUES (50, ‘CONTABILIDAD') |
Sentencia SELECT
Image:
Logo Azure Sql (image/png)
|
SELECT [ALL/DISTINCT] select_list FROM table [table alias] [,...] [WHERE condition] [GROUP BY column_list] [HAVING condition] [ORDER BY column_name [ASC/DESC] [,...] |
Want to create your own Flashcards for free with GoConqr? Learn more.