Globally search and replace data in SQL Server

By Rob Volk on 06 November 2002 | 0 Comments | Tags: Stored Procedures

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." Follow the link to Globally search and replace data in SQL Server...

Discuss this article: 0 Comments so far. Print this Article. This page has been read 9,794 times.

If you like this article you can sign up for our newsletter. We send it out each week that we post a new article. There's an opt-out link at the bottom of each newsletter so it's easy to unsubscribe at any time.

Email Address:

Email This • Subscribe to this feed • Kick it • Save to del.icio.us • View blog reactions

Debugging Stored Procedures in Visual Studio 2005 (25 June 2007)

Writing CLR Stored Procedures in C# - Returning Data (Part 2) (23 June 2005)

Writing CLR Stored Procedures in C# - Introduction to C# (Part 1) (6 June 2005)

Managed Data Access Inside SQL Server with ADO.NET and SQLCLR (31 May 2005)

An Evaluation of Stored Procedures for the .NET Developer (22 March 2004)

Run CLR code from a stored procedure (14 October 2003)

How to search all columns of all tables for a keyword? (31 July 2002)

Query Recompilation in SQL Server 2000 (10 June 2002)