Skip to content

Instantly share code, notes, and snippets.

@morriekken

morriekken/base64.sql

Created August 13, 2020 08:32
Show Gist options
  • Save morriekken/ef7110afe23bed9569fc517d9ba06948 to your computer and use it in GitHub Desktop.
Save morriekken/ef7110afe23bed9569fc517d9ba06948 to your computer and use it in GitHub Desktop.
Download ZIP
SQL, BASE64 conversions
Raw
base64.sql
SELECT CAST('string' as varbinary(max)) FOR XML PATH(''), BINARY BASE64
SELECT CAST( CAST( 'c3RyaW5n' as XML ).value('.','varbinary(max)') AS varchar(max) )
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment