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

0 vote125 views1 answer
Query only first letter string
SQL
0 vote120 views1 answer
Mysql create pool
SQL
0 vote120 views1 answer
Oracle remove line breaks
SQL
2 votes173 views5 answers
Install postgresql 10 centos 7
SQL
6 votes125 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
2 votes111 views3 answers
Row number mssql
SQL
2 votes129 views1 answer
Mysql id of inserted row
SQL
1 vote133 views1 answer
T-SQL / AZURE Reseed
SQL
0 vote119 views1 answer
Mysql count grouped rows
SQL
0 vote126 views1 answer
Mysqli_connect using prepare statement
SQL