sql_cheat_sheet

This is an old revision of the document!

Table of Contents

SQL Cheat Sheet
- INSERT
- UPDATE

SQL Cheat Sheet

INSERT

-- Combining an INSERT with a SELECT.
INSERT
	Table1 (
		  Col1
		, Col2
		, Col3
	)
SELECT
	  Table2.Col1
	, Table2.Col2
	, Table2.Col3
FROM
	Table2

UPDATE

-- Combining an UPDATE with a SELECT.
UPDATE
	Table1
SET
	  Table1.Col1 = Table2.Col1
	, Table1.Col2 = Table2.Col2
FROM
	Table1
INNER JOIN
	Table2
ON
	Table2.Id = Table1.Id

sql_cheat_sheet.1334785851.txt.gz · Last modified: 2017/01/01 19:52 (external edit)