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

-1 vote339 views1 answer
Mysql coalesce
SQL
1 vote350 views1 answer
Timestamp in sqlite
SQL
2 votes376 views1 answer
Search query in mysql
SQL
2 votes344 views6 answers
In in sql
SQL
0 vote350 views1 answer
Resolved [java.sql.SQLException: ORA-29977: Unsupported column type for query registration in guaranteed mode ]
SQL
18 votes360 views3 answers
Mysql current date
SQL
0 vote350 views1 answer
Mysql procedure between two tables
SQL
3 votes347 views1 answer
Oracle undo tablespace list by user
SQL
32 votes379 views6 answers
How to change column name in sql
SQL
0 vote384 views1 answer
Sql sum if
SQL