Collections:
Binary Literals in SQL Server Transact-SQL
What are binary literals supported in SQL Server Transact-SQL?
✍: FYIcenter.com
Binary literals in Transact-SQL are sequences of bytes
written in hexadecimal digits with 0x prefixes.
Binary literals are used to provide values to binary variables or table columns like BINARY, VARBINARY, IMAGE, etc.
Here are some simple rules on how to write binary literals:
Here are some example on how to write exact numeric literals:
PRINT 0xff; PRINT 0x00ff; PRINT 0x00ff00; DECLARE @var BINARY(4); SET @var = 0x41424344; PRINT @var;
⇒ Entering Binary String Literals in SQL Server Transact-SQL
⇐ Approximate Numeric Literals in SQL Server Transact-SQL
2017-05-05, 15943🔥, 0💬
Popular Posts:
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...