Home Forums SQL Server 2012 SQL 2012 - General Symmetrically encrypt a single node in XML field RE: Symmetrically encrypt a single node in XML field

  • May 2, 2014 at 4:55 am

    #1710299

    Eirikur Eiriksson (5/1/2014)

    Lowell, you where almost there! Changed the code to modify and store the encrypted secret, then decrypt in the select. This code has everything needed for either storing the encrypted secret within the xml or for ripping it out and storing it elsewhere.:

    😎

    wow awesome job cleaning up and expanding my modest example, Eirikur! I've saved your modifications in my snippets.

    I got so stuck on extracting out the varbinary to feed the decrypt function.

    When that wouldn't work for me, i gave up and looked for lower hanging forum posts 😎

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!