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, 10048🔥, 0💬
Popular Posts:
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...