Base64 encode sql server

--String to Base64
SELECT CAST('string' as varbinary(max)) FOR XML PATH(''), BINARY BASE64

--Base64 to String
SELECT CAST( CAST( 'c3RyaW5n' as XML ).value('.','varbinary(max)') AS varchar(max) )

Source: stackoverflow.com

Similar codes

3 votes294 views1 answer
Oracle list privileges
SQL
1 vote282 views1 answer
Is sql fast
SQL
0 vote264 views1 answer
How to check if there is no database schema
SQL
0 vote313 views2 answers
Mysql insert into multiple tables
SQL
0 vote269 views1 answer
Mysql workbench procedure
SQL
0 vote315 views1 answer
Insufficient privileges while creating view in sql oracle
SQL
0 vote266 views1 answer
Postgresql regular expression special characters
SQL
1 vote324 views1 answer
Oracle drop temporary table
SQL
0 vote276 views1 answer
Varchar format not case sensitive sql
SQL
25 votes278 views4 answers
Metadata
SQL