Skip to content

Instantly share code, notes, and snippets.

View brianheineman's full-sized avatar

Brian Heineman brianheineman

  • 10:36 (UTC -07:00)
View GitHub Profile
Schema management; how do you manage "n" database schemas being managed?
Production Example
------------------
UPDATE project_affiliation pa
SET hasCommented = 1
WHERE ISNULL(pa.endedAt)
AND hasCommented <> 1
AND EXISTS (
SELECT 1