Blog Post

Sql Server - Find and Replace a value across all tables in database

,

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

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating