Collections:
AND, OR, XOR, and NOT - Bitwise Operations in SQL Server
What Are Bitwise Operations in SQL Server Transact-SQL?
✍: FYIcenter.com
Bitwise operations are binary operations performed on one or two binary strings. SQL Server supports 4 bitwise operations:
The table below shows you how single bit Boolean operations work:
Input 1: 0 0 1 1 Input 2: 0 1 0 1 ---------------- & (AND) 0 0 0 1 Input 1: 0 0 1 1 Input 2: 0 1 0 1 ---------------- | (OR) 0 1 1 1 Input 1: 0 0 1 1 Input 2: 0 1 0 1 ---------------- ^ (XOR) 0 1 1 0 Input 1: 0 0 1 1 ---------------- ~ (NOT) 1 1 0 0
⇒Character Strings and Binary Strings in SQL Server Transact-SQL
2017-02-25, 1607👍, 0💬
Popular Posts:
What Is a Constant or Literal in SQL Server Transact-SQL? A constant, or data literal, is a symbolic...
What Causes Index Fragmentation in SQL Server? Index fragmentation is usually caused by deleting of ...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
How To Create a Simple Stored Procedure in SQL Server Transact-SQL? If you want to create a simple s...