update field inside table
Posted on 2014-08-01
Hi, i have one table with some fields that were hacked and all ntext and varchar fields were added some text inside. I need to update all rows and fields that have this text to take out the text and leave the rest inside.
lets say that the table name is mytable and I have a lots of fields, so i need some query to get the fields name automatic and then go over all rows and check if the field have the text lets say "hacked text", then i need to take out only the part hacked text inside the fields