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, 2567🔥, 0💬
Popular Posts:
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't wan...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...