base64.sql

来自「关于SQL SERVER 的加密和解密包」· SQL 代码 · 共 16 行

-- BASE64.SQL sample script demonstrating xp_base64encode and xp_base64decode
--
-- Michael Coles, MCDBA
-- 7/2005
--
DECLARE @plain VARCHAR(255)
SET @plain = 'THIS IS A TEST, THIS IS ONLY A TEST'

EXEC master..xp_base64encode @plain

DECLARE @base64 VARCHAR(255)
SET @base64 = 'VEhJUyBJUyBBIFRFU1QsIFRISVMgSVMgT05MWSBBIFRFU1Q='

EXEC master..xp_base64decode @base64