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

7 votes337 views2 answers
Show size database mysql
SQL
5 votes310 views3 answers
Truncate function in sql oracle
SQL
0 vote341 views1 answer
How to select a row in sql
SQL
9 votes333 views3 answers
Show table columns mysql command line
SQL
19 votes356 views6 answers
Mysql if null
SQL
0 vote321 views1 answer
Sql create table with references not primary key
SQL
1 vote384 views1 answer
How not to sort by average rating
SQL
0 vote328 views1 answer
Mysql preg replace
SQL
0 vote320 views1 answer
How to get table current identity value in sql server
SQL
0 vote351 views1 answer
Psql initialization
SQL