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, 5093🔥, 0💬
Popular Posts:
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an ...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...