Show Menu
Cheatography
  1. Home >
  2. Cheat Sheets >

MSSQL basic Statements Cheat Sheet by

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

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 = 'foobar'
 
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 = 'AWFUL'
 
FROM
 
TBL1 a
 
(WHATEVER) JOIN
 
TBL2 b
 
ON b.X = a.Y
 
WHERE
 
b.Q
 
IN ('bull', 'shit')
 

Metadata

  • Languages:
  • Published: 12th March, 2022

Comments

No comments yet. Add yours below!

Add a Comment

Your Comment

Please enter your name.

    Please enter your email address

      Please enter your Comment.

          Related Cheat Sheets

          Web Programming Cheat Sheet
          SQL Server Cheat Sheet
          SQL Cheat Sheet