Common Sql Snippets

commonSql_1.sql

-- Update statement with join
UPDATE Table1
  SET Table1.LastName = 'DR. XXXXXX' 
FROM Table1 T1, Table2 T2
WHERE T1.id = T2.id
and T1.id = '010008'

-- Alter column on existing table
ALTER TABLE {TABLENAME} 
ADD {COLUMNNAME} {TYPE} {NULL|NOT NULL} 
CONSTRAINT {CONSTRAINT_NAME} DEFAULT {DEFAULT_VALUE}

-- Multiple CASE statement
CASE WHEN refnumber = '223' then 'true'
     WHEN notes = 'denied' then 'false'
ELSE null as 'ColumnTitle'