SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

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

Help on SQL Server

Devendra Kumar Thakur has a Master's Degree in Computer Applications from Jabalpur Engineering College, and has worked as a Lead Consultant with companies such as Siemens, Accenture, and his current employer, ITC. The majority of his experience is with SQL Server, SSRS, and Crystal report as a developer, however he is now trying to learn SSAS.

Comments

Leave a comment on the original post [helponmsbi.blogspot.com, opens in a new window]

Loading comments...