22,300
社区成员




USE tempdb
GO
IF OBJECT_ID('[dbo].[html_helper_data]') IS NOT NULL
DROP TABLE [dbo].[html_helper_data]
GO
CREATE TABLE [dbo].[html_helper_data](
[id] [int] IDENTITY(1,1) NOT NULL,
[theChar] [varchar](5) NOT NULL,
[decStr] [varchar](10) NOT NULL,
[escapeStr] [varchar](10) NOT NULL,
CONSTRAINT [PK_html_helper_data] PRIMARY KEY CLUSTERED
(
[id] ASC
)
)
GO
SET NOCOUNT ON;
INSERT INTO dbo.html_helper_data(theChar,decStr,escapeStr) VALUES('<','','<');
INSERT INTO dbo.html_helper_data(theChar,decStr,escapeStr) VALUES('>','','>');
DECLARE @strHtml NVARCHAR(MAX)
SET @strHtml='<p>'
DECLARE @theChar VARCHAR(20),@escapeStr VARCHAR(20);
SELECT @escapeStr=escapeStr,@theChar=theChar FROM tempdb.dbo.html_helper_data WHERE theChar='<'
SELECT @escapeStr AS escapeStr
,@theChar AS theChar
,@strhtml AS strHtml
,REPLACE(@strHtml,@escapeStr,@theChar) AS result;