SQL Server Engine Tips

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

Browse by Tags

Tagged Content List
  • Blog Post: 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: declare @hexstring varchar(max); set @hexstring ...
  • Blog Post: 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 @str varchar(20); set @str = '3qAAAA=='; select...
Page 1 of 1 (2 items)