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, 2687🔥, 0💬
Popular Posts:
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...