sql_cheat_sheet
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| sql_cheat_sheet [2021/10/18 03:06] – stephen | sql_cheat_sheet [2025/01/13 22:44] (current) – stephen | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== SQL Cheat Sheet ====== | ====== SQL Cheat Sheet ====== | ||
| + | |||
| + | For Postgres SQL, see [[postgres_sql_cheat_sheet|Postgres SQL Cheat Sheet]] | ||
| ===== CREATE ===== | ===== CREATE ===== | ||
| Line 28: | Line 30: | ||
| FROM | FROM | ||
| Table2 | Table2 | ||
| + | |||
| + | -- INSERTing multiple rows. | ||
| + | INSERT INTO Table1 | ||
| + | (Col1, | ||
| + | VALUES | ||
| + | (Data1, Data2, Data3) | ||
| + | , (Data1, Data2, Data3) | ||
| </ | </ | ||
| Line 324: | Line 333: | ||
| WHERE | WHERE | ||
| SourceObjects.object_id IS NULL OR NewObjects.object_id IS NULL | SourceObjects.object_id IS NULL OR NewObjects.object_id IS NULL | ||
| + | </ | ||
| + | |||
| + | ===== Export a .bacpac By Command Line ===== | ||
| + | |||
| + | Install SqlPackage: | ||
| + | < | ||
| + | dotnet tool install -g microsoft.sqlpackage | ||
| + | </ | ||
| + | |||
| + | Export .backpac. Only add the '' | ||
| + | < | ||
| + | SqlPackage / | ||
| </ | </ | ||
sql_cheat_sheet.1634526405.txt.gz · Last modified: 2021/10/19 04:06 (external edit)