DECLARE @str NVARCHAR(MAX)= '
<!DOCTYPE html>
<html>
<head>
</head>
<body>
<div>哈哈哈</div>
</body>
</html> '
方法：
CREATE FUNCTION [dbo].[removehtml] ( @str NVARCHAR(MAX) )
RETURNS NVARCHAR(MAX)
AS
BEGIN
WHILE CHARINDEX('<', @str) > 0
BEGIN
SET @str = STUFF(@str, CHARINDEX('<', @str),
CHARINDEX('>', @str) - CHARINDEX('<', @str)
+ 1, '') ;
END
RETURN @str
END ;