Cheatography
Login Register

MSSQL basic Statements Cheat Sheet

A cheat sheet in English by eojin

Because I never recall how to write anything after "UPDATE".

SQL
2,707 views 1,483 downloads 12 Mar 2022 History
PRs
Download

SELECT ... JOIN ... WHERE

SELECT
a.COL1
AS '­a1',
 
a.COL2
AS '­a2',
 
c.COL1
AS '­c1'
FROM
TBL1 a
(WHATEVER) JOIN
TBL2 b
ON b.X = a.Y
(WHATEVER) JOIN
TBL3 c
ON c.K = b.K
WHERE
a.K = b.K
AND
c.Z = '­foo­bar­'
GROUP BY
a.COL1,
-- basically specify
 
a.COL2,
-- all selected columns
 
c.COL1
-- when "­GROUP BY"
ORDER BY
b.Q

("su­b-q­uer­y")

WHERE
COL1 IN (
 
SELECT
COL1
 
FROM
TBL337 x
 
(WHATEVER) JOIN
...
 
WHERE
x.Z = '­sub­'
 
)

CTE

WITH
TEMP
AS (
 
SELECT
foo
 
FROM
tbl1
 
UNION ALL
 
SELECT
b.foo
 
FROM
TEMP a
 
INNER JOIN
tbl1 b
 
ON
b.foo
= a.foo
)
SELECT
*
FROM
TEMP
OPTION
(MAXRE­CURSION 5)

UPDATE ... JOIN ... WHERE

UPDATE
TBL1
SET
COL1 = '­GOD­',
 
COL2 = '­AWF­UL'
FROM
TBL1 a
(WHATEVER) JOIN
TBL2 b
ON b.X = a.Y
WHERE
b.Q
IN ('bu­ll', '­shi­t')

Comments

No comments yet.

Cheatography n. The art of mapping complex subjects into clear, instantly navigable reference guides.