MS-SQL html 태그 삭제

CREATE PROCEDURE [common].[P_COMMON_RESTWORD_FILTERING_R]

(
      @i_check_body                    NVARCHAR(MAX)
,     @o_body_filtering_word           NVARCHAR(MAX) OUTPUT
)

AS

DECLARE

 @v_while_counter                 INT
,      @v_body                           VARCHAR(MAX)

,      @v_changebody                     VARCHAR(MAX) 

,      @start_body                       INT

,      @end_body                         INT

 

 

 

BEGIN

 

       SET NOCOUNT ON

                                 

SELECT @v_body                          = '';

       SELECT @v_changebody                     = '';

       SELECT @start_body                       = 0;

       SELECT @end_body                         = 0;

 

 

SELECT @v_while_counter = 1;

WHILE @v_while_counter <= len(@i_check_body)BEGIN                           

IF SUBSTRING(@i_check_body, @v_while_counter, 1) = '<'

       BEGIN

              SELECT @start_body = @v_while_counter;

       END;

       ELSE IF SUBSTRING(@i_check_body, @v_while_counter, 2) = '/>'

       BEGIN             SELECT @end_body = @v_while_counter - @start_body +1;

  SELECT @v_body = SUBSTRING(@i_check_body, @start_body, @end_body);            

             SELECT @o_body_filtering_word = SUBSTRING(@i_check_body, @v_body, '');                

       END;

                                           

       SELECT @v_while_counter = @v_while_counter + 1;

END;