Collections:
Concatenating Two Binary Strings in SQL Server
How To Concatenate Two Binary Strings Together in SQL Server Transact-SQL?
✍: FYIcenter.com
SQL Server 2005 allows to concatenate two binary strings into a single string with the (+) operator. The following tutorial exercise shows you some binary string concatenation examples:
-- Concatenating two binary string literals SELECT 0x57656C636F6D6520746F20 + 0x46594963656E7465722E636F6D; GO 0x57656C636F6D6520746F2046594963656E7465722E636F6D -- Watch out: This is not a binary string concatenation SELECT '0x57656C636F6D6520746F20' + '0x46594963656E7465722E636F6D'; GO 0x57656C636F6D6520746F200x46594963656E7465722E636F6D -- Concatenating two binary strings SELECT CONVERT(VARBINARY(40),'Welcome to ') + CONVERT(VARBINARY(40),'FYIcenter.com'); GO 0x57656C636F6D6520746F2046594963656E7465722E636F6D -- Binary strings can not be concatenated with character strings SELECT 'Welcome to ' + 0x46594963656E7465722E636F6D; GO Msg 402, Level 16, State 1, Line 1 The data types varchar and varbinary are incompatible in the add operator.
⇒ Using Binary Strings in Arithmetical Operations in SQL Server
⇐ CHARINDEX() and SUBSTRING() - Locating and Taking Substrings in SQL Server
⇑ Character Strings and Binary Strings in SQL Server Transact-SQL
2017-03-07, 2084🔥, 0💬
Popular Posts:
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
How To View Data Files in the Current Database in Oracle? If you want to get a list of all tablespac...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...