Home Forums Article Discussions Article Discussions by Author Discuss content posted by Devendra Thakur Find and Replace a value across all tables in database RE: Find and Replace a value across all tables in database
Ed Wagner
SSC Guru
Points: 287026
More actions
April 30, 2017 at 3:51 pm
#1940515
After the loop, the first thing I noticed was the data type mismatch. That found not be fun.
That said, what Jeff and Perry said holds true. All that duplicated data means it's time to invest in a redesign.
Tally Tables - Performance PersonifiedString Splitting with True PerformanceBest practices on how to ask questions