rot13.sql

关于SQL SERVER 的加密和解密包

-- ROT13.SQL sample script demonstrating xp_rot13
--
-- Michael Coles, MCDBA
-- 7/2005
--
DECLARE @plain VARCHAR(255)
DECLARE @encrypted VARCHAR(255)

SET @plain = 'HELLO, HOW ARE YOU?'
EXEC master..xp_rot13 @plain

SET @encrypted = 'URYYB, UBJ NER LBH?'
EXEC master..xp_rot13 @encrypted

SET @encrypted = 'PNRFNE JBHYQ OR CEBHQ!'
EXEC master..xp_rot13 @encrypted