RSA Scripts

Replace text in SP

Replace text in SP.

  1. Sql Server
  2. String manipulation
  3. Intermediate
  4. Vaknin Sammy

Last updated:

Warning: Review and test in a non-production environment before running.

Back to results

CREATE FUNCTION dbo.fnReplaceWords (@body VARCHAR(MAX), @lookFor)
RETURNS VARCHAR(MAX)
AS
BEGIN
    SELECT @body = REPLACE(definition,'0','111')
    FROM sys.sql_modules
    WHERE definition like @lookFor;
    
    RETURN @body;
END 

-- update the metadata.

UPDATE sys.sql_modules
   SET definition = dbo.fnReplaceWords(definition,'xyzxyz');