SQL REPLACE Overview and Examples - SQL Server Tips
https://www.mssqltips.com/sqlservertip/6651/sql-server-replace/
WebJan 24, 2022 · /* Example: Update multiple records */ SET NOCOUNT ON; SELECT sjs. command AS [Original Command], REPLACE (sjs. command, '\\oldslowstorage\sql\backups', '\\FANCYNEWSTORAGE\database\backups') AS [New Command] FROM msdb.. sysjobs sj INNER JOIN msdb.. sysjobsteps sjs ON sjs. job_id …
DA: 36 PA: 44 MOZ Rank: 96