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

8 votes212 views1 answer
My sql version
SQL
0 vote212 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
2 votes261 views1 answer
Create mysql user on all hosts
SQL
1 vote188 views1 answer
Temp table vs variable table in sql server
SQL
3 votes243 views1 answer
Oracle detect invalid password
SQL
0 vote193 views1 answer
Oracle archivemode
SQL
1 vote142 views1 answer
Full text index mysql
SQL
5 votes280 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
0 vote280 views2 answers
Search stored procedures by name
SQL
0 vote194 views1 answer
What is delimiter in mysql
SQL