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, 4881🔥, 0💬
Popular Posts:
How To Set Up SQL*Plus Output Format in Oracle? If you want to practice SQL statements with SQL*Plus...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...