SELECT CAST(CAST(N'' AS XML).value('xs:base64Binary(sql:column("w.salary"))', 'VARBINARY(MAX)') AS VARCHAR(MAX)) de FROM [SL].[dbo].[zz_worker_extra] as w

https://social.technet.microsoft.com/wiki/contents/articles/36388.transact-sql-convert-varbinary-to-base64-string-and-vice-versa.aspx

DECLARE @encoded varchar(max) = 'SGVsbG8gTWFzdGVyIEZvbwo=' SELECT @encoded AS encoded ,CAST(CAST(N'' AS XML).value('xs:base64Binary(sql:variable("@encoded"))', 'VARBINARY(MAX)') AS VARCHAR(MAX)) as decoded 26.03.21

https://medium.com/falafel-software/t-sql-easy-base64-encoding-and-decoding-872ad184bd7e

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2024