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_sha1 Calculates SHA1 hash of the given string accordingly to RFC 3174 Syntax xp_sha1  variable1 [, variable2 , variable3 ...], @hash OUTPUT Arguments text VARCHAR. Source text hash VARCHAR or VARBINARY. Variable that holds the hash value. It has a constant size of 40 chars or 20 bytes in the binary form. Permissions Execute permissions default to the public role. Return Code Values 0 - success, or Error code if failed. hash IS NOT NULL  (success) or IS NULL  (failure) Example declare @encrypted_password varchar(40)   -- Output result should not be less than 40 chars declare @clear_password varchar(16) select @clear_password='abc' exec xp_sha1 @clear_password,@encrypted_password OUTPUT select @encrypted_password The output should be : ---------------------------------------- A9993E364706816ABA3E25717850C26C9CD0D89D