Shulou(Shulou.com)05/31 Report--

Sql Server how to remove the Html tag in the content, I believe that many inexperienced people do not know what to do, so this article summarizes the causes of the problem and solutions, through this article I hope you can solve this problem.

Share a method, remove the Html tags from the content, and test the data:

DECLARE @ str NVARCHAR (max) = ''

The methods are as follows:

CREATE FUNCTION [dbo]. [removehtml] (@ str NVARCHAR (MAX)) RETURNS NVARCHAR (MAX) AS BEGIN WHILE CHARINDEX ('

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.