Change SQL Server bit field to the opposite value using ~

Category SQL Sub Category Language TSQL
Bookmark and Share
In sql server you can flip the bit field value by using the ~ (tilde) operator
For example if you had a bit column called IsActive you would call the column as 

Copy Code

select ~IsActive AS NotActive


To get the opposite boolean value
Share the love
Bookmark and Share

Choose a SubCategory

Backup Recovery
BCP
Blogs
Calculations
Concurrency
Cursors
Data Transfer Restore
Database Compare
Database Investigation
Database Server
Database State
Date And Time
Enterprise Library 4.1
Enterprise Manager
Error Handling
Functions
General
Language TSQL
Links
LINQ
Performance
Permissions
Purge Move Data
Shrink DB Files
SSRS Rpting Services
Standards
Stored Procedures
Temporary Tables
Transaction Log
Views