SQLTeam.com Logo

Return to Globally search and replace data in SQL Server

Globally search and replace data in SQL Server

Written by Rob Volk on 06 November 2002

Narayana Vyas Kondreddi submitted "This article provides you with a simple stored procedure, that can search all the columns of all the tables in the current database, and replace a given search string with another string."