Home    XP_CRYPT Online Help Prev Next
How To use XP_CRYPT GUI
Introduction
What is XP_CRYPT
System requirements
Free version limitations
End user license agreement
Installing XP_CRYPT
Installation procedure
Activation
XP_CRYPT API
What's new
Encryption methods overview
Session
xp_crypt_set_var
xp_crypt_get_var
xp_crypt_close_session
xp_crypt_init_session
xp_crypt_set_option
Asymmetric keys
DSA
xp_dsa_free_key
xp_dsa_load_key
xp_dsa_save_key
xp_dsa_generate_couple
RSA
xp_rsa_generate_couple
xp_rsa_generate_pub_key
xp_rsa_load_key
xp_rsa_priv_dec
xp_rsa_pub_enc
xp_rsa_save_key
xp_rsa_free_key
Digital signatures
DSA
xp_dsa_verify
xp_dsa_sign
RSA
xp_rsa_sign
xp_rsa_verify
Hashing
xp_crypt
xp_md5
xp_sha1
Symmetric encryption
AES128
xp_aes128_decrypt
xp_aes128_encrypt
AES
xp_aes_decrypt
xp_aes_encrypt
DESX
xp_desx_decrypt
xp_desx_encrypt
RC4
xp_rc4_decrypt
xp_rc4_encrypt
Triple DES
xp_des3_encrypt
xp_des3_decrypt
Error codes
Tutorial
How to use GUI
Advanced technique (Old)
Table encryption (Old)
Troubleshooting
Troubleshooting overview

xp_desx_decrypt

Decrypts data previously encrypted with xp_desx_encrypt algorithm.

Syntax

xp_desx_decrypt  {  encrypted_text  , password, key, variable1 OUTPUT [, variable2 OUTPUT , variable3 OUTPUT ...]

Arguments

encrypted_text 

VARCHAR. Text previously encrypted with xp_desx_encrypt function.

password

VARCHAR. Your hard password. Exactly the same that is used for encryption. 

key 

VARCHAR. Initializing the key. Exactly the same that is used for encryption. It must be exactly 8 chars.

variable1 OUTPUT [, variable2 OUTPUT , variable3 OUTPUT ...]

Variables to hold the decrypted information. The order of the variables should be the same with the order of the variables given to the encryption function.

Remark

If you specify the wrong password the decryption will succeed but clear_text will probably hold some garbage. You are not able to find out if the password was wrong or correct.

Permissions

Execute permissions default to the public role.

Return Code Values

0 - success, or Error code if failed.

Return Code Values
declare @encrypted varchar(8000)
declare @return_code 

exec xp_desx_encrypt 'clear','MyPassword','12345678',@encrypted OUTPUT
exec @return_code = xp_desx_decrypt @encrypted ,'MyPassword','12345678',@encrypted OUTPUT
if @return_code != 0
begin
raiserror ('DESX encryption failed!',16,10)
end

Browser Based Help. Published by chm2web software.