Find and Replace a value across all tables in database
In my project I faced this problem due to typing mistakes.
End user has entered ‘goodmorning’ and ‘good morning’ interchangeably
and it was causing logic failure at application level. So task was to replace ‘goodmorning’
with ‘good morning’ in database wherever it is there. So I came up with this
simple script. It worked for me but