Differences

This shows you the differences between two versions of the page.

--- sql_cheat_sheet [2020/07/06 01:25] – stephen
+++ sql_cheat_sheet [2025/01/13 22:44] (current) – stephen
@@ Line 1: / Line 1: @@
 ====== SQL Cheat Sheet ======
+For Postgres SQL, see [[postgres_sql_cheat_sheet|Postgres SQL Cheat Sheet]]
 ===== CREATE =====
@@ Line 28: / Line 30: @@
 FROM
 	Table2
+-- INSERTing multiple rows.
+INSERT INTO Table1
+	  (Col1,  Col2,  Col3)
+VALUES
+	  (Data1, Data2, Data3)
+	, (Data1, Data2, Data3)
 </code>
@@ Line 39: / Line 48: @@
 	  Table1.Col1 = Table2.Col1
 	, Table1.Col2 = Table2.Col2
+FROM
+	Table1
+INNER JOIN
+	Table2
+ON
+	Table2.Id = Table1.Id
+</code>
+===== DELETE =====
+<code sql>
+-- Combining an UPDATE with a JOIN.
+DELETE
+	Table1
 FROM
 	Table1
@@ Line 253: / Line 276: @@
 </code>
-===== Determine the Data Types in Results of a Query=====
+===== Determine the Data Types in Results of a Query =====
 <code sql>
 SELECT * FROM sys.dm_exec_describe_first_result_set(
    N'EXEC SomeStoredProcedure 1234', NULL, 0);
+</code>
+===== Sort out Collation =====
+<code sql>
+-- Determine the default collation for the server.
+SELECT serverproperty('collation')
+-- Convert a varchar to a specific collation.
+SELECT CAST('abc' AS VARCHAR(5)) COLLATE Latin1_General_CI_AS
 </code>
@@ Line 300: / Line 333: @@
 WHERE
     SourceObjects.object_id IS NULL OR NewObjects.object_id IS NULL
+</code>
+===== Export a .bacpac By Command Line =====
+Install SqlPackage:
+<code>
+dotnet tool install -g microsoft.sqlpackage
+</code>
+Export .backpac. Only add the ''Encrypt=False'' for local exports.
+<code>
+SqlPackage /Action:Export /TargetFile:"D:\Dev\BucketsOfFundsSQL\$((Get-Date).ToString("yyyyMMdd")) Buckets.bacpac" /SourceConnectionString:"Integrated Security=SSPI;Persist Security Info=False;Encrypt=False;Initial Catalog=Buckets;Data Source=."
 </code>
@@ Line 479: / Line 524: @@
 <code sql>
-DECLARE @searchText NVARCHAR(MAX) = N'Foo';
+DECLARE @searchText NVARCHAR(20) = N'Foo';
 DECLARE @sql NVARCHAR(MAX) = N'';