sql server - Mixing an IF-statement in an UPDATE ... - Stack Overflow

UPDATE bc SET IsFlagged = CASE WHEN b.ID IS NULL THEN 0 ELSE 1 END FROM BookCategory ...

stackoverflow.com