MS-SQL: html 태그 제거하기 / html tag remove

html 태그 제거 함수 SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER FUNCTION [dbo].[cleanHTML](@strHTML VARCHAR(8000)) RETURNS VARCHAR(8000) AS BEGIN DECLARE @strTEXT VARCHAR(8000) DECLARE @char VARCHAR(2) DECLARE @len INT DECLARE @i INT SET @strTEXT = '' SET @char = '' SET @len = LEN(@strHTML) SET @i = 1 WHILE @i ') SET @strTEXT = REPLACE(@strTEXT, '

원문링크 : MS-SQL: html 태그 제거하기 / html tag remove