Html entity decode in sql query

DECLARE @htmlNames TABLE 
(
    ID INT IDENTITY(1,1), 
    asciiDecimal INT, 
    htmlName varchar(50)
);

INSERT INTO @htmlNames 
VALUES 
    (34,'"'),
    (38,'&'),
    (60,'<'),
    (62,'>'),
    (160,' '),
    (161,'¡'),
    (162,'¢')
;

DECLARE @inputString varchar(max)= '&test&quot;<String>"&';
DECLARE @resultString varchar(max) = @inputString;

-- Simple HTML-decode:
SELECT
    @resultString = Replace(@resultString COLLATE Latin1_General_CS_AS, htmlName, NCHAR(asciiDecimal))
FROM
    @htmlNames
;

SELECT @resultString;
-- Output: &test"<String>"&


-- Multiple HTML-decode:
SET @resultString = @inputString;

DECLARE @temp varchar(max) = '';
WHILE @resultString != @temp
BEGIN
    SET @temp = @resultString;

    SELECT
        @resultString = Replace(@resultString COLLATE Latin1_General_CS_AS, htmlName, NCHAR(asciiDecimal))
    FROM
        @htmlNames
    ;
END;

SELECT @resultString;
-- Output: &test"<String>"&

Source: stackoverflow.com

Similar codes

0 vote263 views2 answers
Tooltip with Html attribute bootstrap 5
Html
0 vote262 views1 answer
Page html vierge
Html
2 votes254 views1 answer
Get directions google maps html
Html
0 vote346 views1 answer
Elasticsearch built-in security features are not enabled. Without authentication, your cluster could be accessible to anyone. See https://www.elastic.co/guide/en/elasticsearch/reference/7.15/security-minimal-setup.html to enable security.
Html
6 votes263 views4 answers
Sweetalert2 cdn
Html
0 vote262 views1 answer
Select file html design
Html
1 vote287 views2 answers
The package flectra needs to be reinstalled, but I can't find an archive for it.
Html
0 vote250 views1 answer
Alpine function
Html
7 votes268 views2 answers
Tab image code
Html
1 vote269 views1 answer
A link in new tab
Html