从 SQL TEXT 列递归删除行

下面是一个解决方案。有关其工作原理的详细信息如下。请注意，此解决方案需要MSSQL 2017+才能工作。

-- Place the raw string value as varchar data in a variable so it is convenient to work with:

declare @rawValue varchar(max) = 'Header_ID askdjfhklasjdhfklajhfwoi fhweiohrognfk
ABC
SECTION_ID asdfhkwjehfi efjhewiu1382204 3904834
123
SECTION_ID deihefgjkahf dfjsdhfkl edfashldfkljh';

-- Perform multiple operations on the raw value and save the result to another variable:

declare @convertedValue varchar(max) = 
(
    select string_agg(value, char(13) + char(10)) 
    from string_split(@rawValue, char(10)) 
    where value not like 'header_id%' and value not like 'section_id%'
);

-- Display converted value.
select @convertedValue;