SELECT CONVERT ( VARCHAR(MAX), CAST('' AS XML).value('xs:base64Binary(sql:column("BASE64_COLUMN"))', 'VARBINARY(MAX)') ) AS RESULT FROM ( SELECT 'cm9sZToxIHByb2R1Y2VyOjEyIHRpbWVzdGFtcDoxNDY4NjQwMjIyNTcxMDAwIGxhdGxuZ3tsYXRpdHVkZV9lNzo0MTY5ODkzOTQgbG9uZ2l0dWRlX2U3Oi03Mzg5NjYyMTB9IHJhZGl1czoxOTc2NA==' AS BASE64_COLUMN ) A
もし、taというテーブルでcol1にデコードしたい場合は以下でデコードできた
select id, col1, CONVERT ( VARCHAR(MAX), CAST('' AS XML).value('xs:base64Binary(sql:column("col1"))', 'VARBINARY(MAX)') ) AS RESULT from ta
https://dba.stackexchange.com/questions/191273/decode-base64-string-natively-in-sql-server
— posted by midilin @ 06:38PM
| Comment (0)
最近のコメント