Collections:
Entering Binary String Literals in SQL Server Transact-SQL
How To Enter Binary String Literals in SQL Server Transact-SQL?
✍: FYIcenter.com
Binary string long values are normally generated by client applications by reading input channels, like image files. But sometimes, you may need to enter some short binary strings as literals. Binary string literals are entered as a string of bytes expressed in HEX numbers and prefixed with (0x).
Input strings will be truncated or padded to fit the storage size of fixed length binary string data type. The padding bytes will be the zero byte: 0x00. The tutorial exercise shows you good examples of truncating and padding fixed length binary strings:
-- Size matches DECLARE @x BINARY(8); SET @x = 0x2605260626402642; PRINT @x; ------------------ 0x2605260626402642 -- Truncated DECLARE @x BINARY(4); SET @x = 0x2605260626402642; PRINT @x; ------------------ 0x26052606 -- Padded DECLARE @x BINARY(12); SET @x = 0x2605260626402642; PRINT @x; ------------------ 0x260526062640264200000000 -- No padding on variable length data type DECLARE @x VARBINARY(8); SET @x = 0x; -- Empty binary string PRINT @x; 0x -- Padding on fixed length data type DECLARE @x BINARY(8); SET @x = 0x; -- Empty binary strings PRINT @x; ------------------ 0x0000000000000000
⇒ Variables and Data Types in SQL Server Transact-SQL
⇐ Binary Literals in SQL Server Transact-SQL
2017-04-22, 1490🔥, 0💬
Popular Posts:
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
How To Set Up SQL*Plus Output Format in Oracle? If you want to practice SQL statements with SQL*Plus...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...