Character Strings and Binary Strings in SQL Server Transact-SQL

Q

Where to find answers to frequently asked questions on Character Strings and Binary Strings in SQL Server Transact-SQL?

✍: FYIcenter.com

A

Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Character Strings and Binary Strings in SQL Server Transact-SQL. Clear answers are provided with tutorial exercises on concatenating character/binary strings; converting Unicode character strings; converting binary strings; inserting new line characters; locating and taking substrings; bitwise operations.

Concatenating Two Character Strings in SQL Server

String Type Conversion During Concatenation in SQL Server

Converting Unicode Strings to Non-Unicode Strings in SQL Server

Character String Functions Supported by SQL Server 2005 in SQL Server

Inserting New Line Characters into Strings in SQL Server

CHARINDEX() and SUBSTRING() - Locating and Taking Substrings in SQL Server

Concatenating Two Binary Strings in SQL Server

Using Binary Strings in Arithmetical Operations in SQL Server

Converting Binary Strings into Integers in SQL Server

Converting Binary Strings into NUMERIC or FLOAT in SQL Server

Converting Binary Strings into Character Strings in SQL Server

Converting Binary Strings into Unicode Character Strings in SQL Server

bin2hex - Converting Binary Strings into Hexadecimal Character Strings in SQL Server

AND, OR, XOR, and NOT - Bitwise Operations in SQL Server

⇒ Concatenating Two Character Strings in SQL Server

⇐ RAND() - Generating Random Numbers in SQL Server

⇑⇑ SQL Server Transact-SQL Tutorials

2017-03-11, 3748🔥, 0💬