如何在sqlserver 2005中加密和解密卡号 [英] how to encrypt and decrypt card number in sqlserver 2005

问题描述

大家好，这里发布了我的存储过程.有人可以帮助我如何加密和解密我的卡吗?

hi all,here am posting my stored procedure.can anybody help me how to encrypt and decrypt my cardno

ALTER procedure [dbo].[Detail_CC_Insert](@CLCardNo varchar(20),@CLCardHolderName varchar(50),@CLPNRNo nchar(10),@CLDateAttempted smalldatetime,@CLAmt smallint, @Status tinyint,@CLTransID varchar(50),@CLRefundDate smalldatetime,@CLApplTrackID nchar(10),@Call_Request_ID int)
as
insert into Call_Detail_CC values(@CLCardNo ,@CLCardHolderName ,@CLPNRNo ,@CLDateAttempted ,@CLAmt ,@Status,@CLTransID,@CLRefundDate ,@CLApplTrackID,@Call_Request_ID)

如果可能，通过rc4或mdf5加密/解密方法进行加密

If possible encrypt through rc4 or mdf5 encryption/decryption methods

推荐答案

您好

Hello

 

谢谢您的发帖！我建议将您的问题发布到其中之一

Thank you for your post!  I would suggest posting your question in one of the

SQL Server开发人员中心 > SQL Server论坛 > SQL Server入门

SQL Server Developer Center > SQL Server Forums > Getting started with SQL Server

这篇关于如何在sqlserver 2005中加密和解密卡号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！