encryption in sql server

Question

can this code be converted into an sql stored procedure

        string key = "test";

        MD5CryptoServiceProvider hashmd5 = new MD5CryptoServiceProvider();
        keyArray = hashmd5.ComputeHash(UTF8Encoding.UTF8.GetBytes(key));
        hashmd5.Clear();

        TripleDESCryptoServiceProvider tdes = new TripleDESCryptoServiceProvider();
        tdes.Key = keyArray;
        tdes.Mode = CipherMode.ECB;
        tdes.Padding = PaddingMode.PKCS7;

        ICryptoTransform cTransform = tdes.CreateEncryptor();
        byte[] resultArray = cTransform.TransformFinalBlock(toEncryptArray, 0, toEncryptArray.Length);
        tdes.Clear();
        return Convert.ToBase64String(resultArray, 0, resultArray.Length);

podiluska · Accepted Answer · 2012-07-18 09:19:53Z

1

HASHBYTES can do the first part.

For the second, look at ENCRYPTBYKEY which can encrypt using a Triple DES key.

See http://msdn.microsoft.com/en-us/library/ms179331(v=sql.100).aspx for examples

Alternatively, you may want to consider a SQL CLR procedure.

answered Jul 18, 2012 at 9:19

podiluska

51.6k7 gold badges102 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

encryption in sql server

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related