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
⇒ Date/Time Operations and Functions in SQL Server Transact-SQL
⇐ bin2hex - Converting Binary Strings into Hexadecimal Character Strings in SQL Server
⇑ Character Strings and Binary Strings in SQL Server Transact-SQL
2017-02-25, 4925🔥, 0💬
Popular Posts:
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...