Jump to content

SQL String comparison / SQL sting variables to array


Recommended Posts

I have an audit trail that record users ids and a copy of the sql string for any updates they make to my application. This is very easy for me to follow to  find exactly where changes happened but do end users it is a bit of a challenge.


Has anyone seen or made a script that can either compare two sql strings to see what fields have different values or a script that takes an SQL string and outputs its field names and values to an array that I can use for comparisons?


Example being the look at a update made by user X, the database pulls the sql for that change then looks for the previous change up any user before (update sql should have a value for all fields) then compares to see what user X changed.


If not im thinking of case statement to divide sql request between inserts and update then writing a script to split the strings based on where the commas were.


Any thoughts?

Link to comment
Share on other sites

This thread is more than a year old.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.