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, 2510🔥, 0💬
Popular Posts:
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...