SQL Server Engine Tips

Guidelines, Best Practices, TSQL and SQL Programming Tips & Tricks.

This Blog

About
Email

Syndication

Search

News

These postings are provided
"AS IS" with no warranties,
and confers no rights.
Use of included script samples
are subject to the terms
specified at http://www.microsoft.com/ info/cpyright.htm.

SQL Server 2005

SQL Server Document Links

Browse by Tags

All Tags » Programming » SQL Server 2005 (RSS)

Converting from hex string to varbinary and vice versa

Converting hexadecimal values to varbinary and vice versa is now easier using the XQuery functionality available from SQL Server 2005. The code samples below show how to perform the conversion(s): -- Convert hexstring value in a variable to varbinary: Read More...

Posted Wednesday, July 02, 2008 6:26 PM by SQL Server Engine Team | 3 Comments

Filed under: SQL Server 2005, SQL Server 2008, Programming

Converting from Base64 to varbinary and vice versa

Converting Base64 values to varbinary and vice versa is now easier using the XQuery functionality available from SQL Server 2005 onwards. The code samples below show how to perform the conversion: -- Convert Base64 value in a variable to varbinary: declare Read More...

Posted Monday, June 30, 2008 6:25 PM by SQL Server Engine Team | 1 Comments

Filed under: SQL Server 2005, SQL Server 2008, Programming