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, 1545👍, 0💬
Popular Posts:
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
How To Execute a Stored Procedure in SQL Server Transact-SQL? If you want execute a stored procedure...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...