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, 10350🔥, 0💬
Popular Posts:
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...