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; 

SELECT dbo.removehtml(@str)