Collections:
Using Binary Strings in Arithmetical Operations in SQL Server
Can Binary Strings Be Used in Arithmetical Operations in SQL Server Transact-SQL?
✍: FYIcenter.com
Can binary strings be used in arithmetical operations? The answer is yes. But there are two simple rules you need to remember:
The tutorial exercise below shows you some good examples:
SELECT 0x66 + 44 GO 146 SELECT 0x66 - 44 GO 58 SELECT 0x66 * 44 GO 4488 SELECT 0x66 / 44 GO 2 SELECT 0x66 + 0x44 GO 0x6644 SELECT 0x66 - 0x44 GO Msg 8117, Level 16, State 1, Line 1 Operand data type varbinary is invalid for subtract operator. SELECT 0x66 * 0x44 GO Msg 8117, Level 16, State 1, Line 1 Operand data type varbinary is invalid for multiply operator. SELECT 0x66 / 0x44 GO Msg 8117, Level 16, State 1, Line 1 Operand data type varbinary is invalid for divide operator.
⇒ Converting Binary Strings into Integers in SQL Server
⇐ Concatenating Two Binary Strings in SQL Server
⇑ Character Strings and Binary Strings in SQL Server Transact-SQL
2017-02-28, 3228🔥, 0💬
Popular Posts:
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...