?? genkey.sql
字號:
-- GENKEY.SQL sample script demonstrating xp_generatekey
--
-- Michael Coles, MCDBA
-- 7/2005
--
DECLARE @key VARCHAR(255)
EXEC master..xp_generatekey 128, @key OUTPUT
PRINT 'Your Key is: ' + @key
DECLARE @plaintext VARCHAR(255)
SET @plaintext = 'THIS ENCRYPTION WAS BROUGHT TO YOU COURTESY OF BLOWFISH'
PRINT 'Your plain text is: ' + @plaintext
DECLARE @encryptedtext VARCHAR(255)
DECLARE @decryptedtext VARCHAR(255)
EXEC master..xp_blowfishencrypt @plaintext, @key, @encryptedtext OUTPUT
PRINT 'Your encrypted text is: ' + @encryptedtext
EXEC master..xp_blowfishdecrypt @encryptedtext, @key, @decryptedtext OUTPUT
PRINT 'Your decrypted text is: ' + @decryptedtext
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -