How do I flip a bit in SQL Server, Boolean 'NOT' in T-SQL

Use the ~ operator:

DECLARE @Bool bit
SET @Bool = 0
SET @Bool = ~@Bool
SELECT @Boole