T-SQL编码函数

最新推荐文章于 2024-01-03 21:26:04 发布

jhj_hua

最新推荐文章于 2024-01-03 21:26:04 发布

阅读量717

点赞数

文章标签： c lambda uml function image

本文链接：https://blog.csdn.net/jhj_hua/article/details/1759574

版权

用法：SELECT dbo.HTMLDecode('This text contains &quot;encoded&quot; chars &#169;')

CREATE FUNCTION HTMLDecode (@InputString NVARCHAR(4000))
RETURNS NVARCHAR(4000) AS
BEGIN
DECLARE @vcResult NVARCHAR(4000)
DECLARE @vcCrLf NVARCHAR(2)
DECLARE @siPos SMALLINT
DECLARE @vcEncoded NVARCHAR(7)
DECLARE @siChar SMALLINT

SET @vcCrLF = CHAR(13) + CHAR(10)

SELECT @vcResult = @InputString
SELECT @siPos = PATINDEX('%&#___;%', @vcResult)
WHILE (@siPos > 0)
BEGIN
  SELECT @vcEncoded = SUBSTRING(@vcResult, @siPos, 6)
  SELECT @siChar = CAST(SUBSTRING(@vcEncoded, 3, 3) AS SMALLINT)
  SELECT @vcResult = REPLACE(@vcResult, @vcEncoded, NCHAR(@siChar))
  SELECT @siPos = PATINDEX('%&#___;%', @vcResult)
END

SELECT @siPos = PATINDEX('%&#____;%', @vcResult)
WHILE (@siPos > 0)
BEGIN
  SELECT @vcEncoded = SUBSTRING(@vcResult, @siPos, 7)
  SELECT @siChar = CAST(SUBSTRING(@vcEncoded, 3, 4) AS SMALLINT)
  SELECT @vcResult = REPLACE(@vcResult, @vcEncoded, NCHAR(@siChar))
  SELECT @siPos = PATINDEX('%&#____;%', @vcResult)
END

SELECT @vcResult = REPLACE(@vcResult, '"', NCHAR(0x0022))
SELECT @vcResult = REPLACE(@vcResult, '&', NCHAR(0x0026))
SELECT @vcResult = REPLACE(@vcResult, '<', NCHAR(0x003c))
SELECT @vcResult = REPLACE(@vcResult, '>', NCHAR(0x003e))
SELECT @vcResult = REPLACE(@vcResult, ' ', NCHAR(0x00a0))
SELECT @vcResult = REPLACE(@vcResult, '¡', NCHAR(0x00a1))
SELECT @vcResult = REPLACE(@vcResult, '¢', NCHAR(0x00a2))
SELECT @vcResult = REPLACE(@vcResult, '£', NCHAR(0x00a3))
SELECT @vcResult = REPLACE(@vcResult, '¤', NCHAR(0x00a4))
SELECT @vcResult = REPLACE(@vcResult, '¥', NCHAR(0x00a5))
SELECT @vcResult = REPLACE(@vcResult, '¦', NCHAR(0x00a6))
SELECT @vcResult = REPLACE(@vcResult, '§', NCHAR(0x00a7))
SELECT @vcResult = REPLACE(@vcResult, '¨', NCHAR(0x00a8))
SELECT @vcResult = REPLACE(@vcResult, '©', NCHAR(0x00a9))
SELECT @vcResult = REPLACE(@vcResult, 'ª', NCHAR(0x00aa))
SELECT @vcResult = REPLACE(@vcResult, '«', NCHAR(0x00ab))
SELECT @vcResult = REPLACE(@vcResult, '¬', NCHAR(0x00ac))
SELECT @vcResult = REPLACE(@vcResult, '', NCHAR(0x00ad))
SELECT @vcResult = REPLACE(@vcResult, '®', NCHAR(0x00ae))
SELECT @vcResult = REPLACE(@vcResult, '¯', NCHAR(0x00af))
SELECT @vcResult = REPLACE(@vcResult, '°', NCHAR(0x00b0))
SELECT @vcResult = REPLACE(@vcResult, '±', NCHAR(0x00b1))
SELECT @vcResult = REPLACE(@vcResult, '²', NCHAR(0x00b2))
SELECT @vcResult = REPLACE(@vcResult, '³', NCHAR(0x00b3))
SELECT @vcResult = REPLACE(@vcResult, '´', NCHAR(0x00b4))
SELECT @vcResult = REPLACE(@vcResult, 'µ', NCHAR(0x00b5))
SELECT @vcResult = REPLACE(@vcResult, '¶', NCHAR(0x00b6))
SELECT @vcResult = REPLACE(@vcResult, '·', NCHAR(0x00b7))
SELECT @vcResult = REPLACE(@vcResult, '¸', NCHAR(0x00b8))
SELECT @vcResult = REPLACE(@vcResult, '¹', NCHAR(0x00b9))
SELECT @vcResult = REPLACE(@vcResult, 'º', NCHAR(0x00ba))
SELECT @vcResult = REPLACE(@vcResult, '»', NCHAR(0x00bb))
SELECT @vcResult = REPLACE(@vcResult, '¼', NCHAR(0x00bc))
SELECT @vcResult = REPLACE(@vcResult, '½', NCHAR(0x00bd))
SELECT @vcResult = REPLACE(@vcResult, '¾', NCHAR(0x00be))
SELECT @vcResult = REPLACE(@vcResult, '¿', NCHAR(0x00bf))
SELECT @vcResult = REPLACE(@vcResult, 'À', NCHAR(0x00c0))
SELECT @vcResult = REPLACE(@vcResult, 'Á', NCHAR(0x00c1))
SELECT @vcResult = REPLACE(@vcResult, 'Â', NCHAR(0x00c2))
SELECT @vcResult = REPLACE(@vcResult, 'Ã', NCHAR(0x00c3))
SELECT @vcResult = REPLACE(@vcResult, 'Ä', NCHAR(0x00c4))
SELECT @vcResult = REPLACE(@vcResult, 'Å', NCHAR(0x00c5))
SELECT @vcResult = REPLACE(@vcResult, 'Æ', NCHAR(0x00c6))
SELECT @vcResult = REPLACE(@vcResult, 'Ç', NCHAR(0x00c7))
SELECT @vcResult = REPLACE(@vcResult, 'È', NCHAR(0x00c8))
SELECT @vcResult = REPLACE(@vcResult, 'É', NCHAR(0x00c9))
SELECT @vcResult = REPLACE(@vcResult, 'Ê', NCHAR(0x00ca))
SELECT @vcResult = REPLACE(@vcResult, 'Ë', NCHAR(0x00cb))
SELECT @vcResult = REPLACE(@vcResult, 'Ì', NCHAR(0x00cc))
SELECT @vcResult = REPLACE(@vcResult, 'Í', NCHAR(0x00cd))
SELECT @vcResult = REPLACE(@vcResult, 'Î', NCHAR(0x00ce ))
SELECT @vcResult = REPLACE(@vcResult, 'Ï', NCHAR(0x00cf))
SELECT @vcResult = REPLACE(@vcResult, 'Ð', NCHAR(0x00d0))
SELECT @vcResult = REPLACE(@vcResult, 'Ñ', NCHAR(0x00d1))
SELECT @vcResult = REPLACE(@vcResult, 'Ò', NCHAR(0x00d2))
SELECT @vcResult = REPLACE(@vcResult, 'Ó', NCHAR(0x00d3))
SELECT @vcResult = REPLACE(@vcResult, 'Ô', NCHAR(0x00d4))
SELECT @vcResult = REPLACE(@vcResult, 'Õ', NCHAR(0x00d5))
SELECT @vcResult = REPLACE(@vcResult, 'Ö', NCHAR(0x00d6))
SELECT @vcResult = REPLACE(@vcResult, '×', NCHAR(0x00d7))
SELECT @vcResult = REPLACE(@vcResult, 'Ø', NCHAR(0x00d8))
SELECT @vcResult = REPLACE(@vcResult, 'Ù', NCHAR(0x00d9))
SELECT @vcResult = REPLACE(@vcResult, 'Ú', NCHAR(0x00da))
SELECT @vcResult = REPLACE(@vcResult, 'Û', NCHAR(0x00db))
SELECT @vcResult = REPLACE(@vcResult, 'Ü', NCHAR(0x00dc))
SELECT @vcResult = REPLACE(@vcResult, 'Ý', NCHAR(0x00dd))
SELECT @vcResult = REPLACE(@vcResult, 'Þ', NCHAR(0x00de))
SELECT @vcResult = REPLACE(@vcResult, 'ß', NCHAR(0x00df))
SELECT @vcResult = REPLACE(@vcResult, 'à', NCHAR(0x00e0))
SELECT @vcResult = REPLACE(@vcResult, 'á', NCHAR(0x00e1))
SELECT @vcResult = REPLACE(@vcResult, 'â', NCHAR(0x00e2))
SELECT @vcResult = REPLACE(@vcResult, 'ã', NCHAR(0x00e3))
SELECT @vcResult = REPLACE(@vcResult, 'ä', NCHAR(0x00e4))
SELECT @vcResult = REPLACE(@vcResult, 'å', NCHAR(0x00e5))
SELECT @vcResult = REPLACE(@vcResult, 'æ', NCHAR(0x00e6))
SELECT @vcResult = REPLACE(@vcResult, 'ç', NCHAR(0x00e7))
SELECT @vcResult = REPLACE(@vcResult, 'è', NCHAR(0x00e8))
SELECT @vcResult = REPLACE(@vcResult, 'é', NCHAR(0x00e9))
SELECT @vcResult = REPLACE(@vcResult, 'ê', NCHAR(0x00ea))
SELECT @vcResult = REPLACE(@vcResult, 'ë', NCHAR(0x00eb))
SELECT @vcResult = REPLACE(@vcResult, 'ì', NCHAR(0x00ec))
SELECT @vcResult = REPLACE(@vcResult, 'í', NCHAR(0x00ed))
SELECT @vcResult = REPLACE(@vcResult, 'î', NCHAR(0x00ee))
SELECT @vcResult = REPLACE(@vcResult, 'ï', NCHAR(0x00ef))
SELECT @vcResult = REPLACE(@vcResult, 'ð', NCHAR(0x00f0))
SELECT @vcResult = REPLACE(@vcResult, 'ñ', NCHAR(0x00f1))
SELECT @vcResult = REPLACE(@vcResult, 'ò', NCHAR(0x00f2))
SELECT @vcResult = REPLACE(@vcResult, 'ó', NCHAR(0x00f3))
SELECT @vcResult = REPLACE(@vcResult, 'ô', NCHAR(0x00f4))
SELECT @vcResult = REPLACE(@vcResult, 'õ', NCHAR(0x00f5))
SELECT @vcResult = REPLACE(@vcResult, 'ö', NCHAR(0x00f6))
SELECT @vcResult = REPLACE(@vcResult, '÷', NCHAR(0x00f7))
SELECT @vcResult = REPLACE(@vcResult, 'ø', NCHAR(0x00f8))
SELECT @vcResult = REPLACE(@vcResult, 'ù', NCHAR(0x00f9))
SELECT @vcResult = REPLACE(@vcResult, 'ú', NCHAR(0x00fa))
SELECT @vcResult = REPLACE(@vcResult, 'û', NCHAR(0x00fb))
SELECT @vcResult = REPLACE(@vcResult, 'ü', NCHAR(0x00fc))
SELECT @vcResult = REPLACE(@vcResult, 'ý', NCHAR(0x00fd))
SELECT @vcResult = REPLACE(@vcResult, 'þ', NCHAR(0x00fe))
SELECT @vcResult = REPLACE(@vcResult, 'ÿ', NCHAR(0x00ff))
SELECT @vcResult = REPLACE(@vcResult, '&OElig;', NCHAR(0x0152))
SELECT @vcResult = REPLACE(@vcResult, '&oelig;', NCHAR(0x0153))
SELECT @vcResult = REPLACE(@vcResult, '&Scaron;', NCHAR(0x0160))
SELECT @vcResult = REPLACE(@vcResult, '&scaron;', NCHAR(0x0161))
SELECT @vcResult = REPLACE(@vcResult, '&Yuml;', NCHAR(0x0178))
SELECT @vcResult = REPLACE(@vcResult, '&fnof;', NCHAR(0x0192))
SELECT @vcResult = REPLACE(@vcResult, '&circ;', NCHAR(0x02c6))
SELECT @vcResult = REPLACE(@vcResult, '&tilde;', NCHAR(0x02dc))
SELECT @vcResult = REPLACE(@vcResult, 'Α', NCHAR(0x0391))
SELECT @vcResult = REPLACE(@vcResult, 'Β', NCHAR(0x0392))
SELECT @vcResult = REPLACE(@vcResult, 'Γ', NCHAR(0x0393))
SELECT @vcResult = REPLACE(@vcResult, 'Δ', NCHAR(0x0394))
SELECT @vcResult = REPLACE(@vcResult, 'Ε', NCHAR(0x0395))
SELECT @vcResult = REPLACE(@vcResult, 'Ζ', NCHAR(0x0396))
SELECT @vcResult = REPLACE(@vcResult, 'Η', NCHAR(0x0397))
SELECT @vcResult = REPLACE(@vcResult, 'Θ', NCHAR(0x0398))
SELECT @vcResult = REPLACE(@vcResult, 'Ι', NCHAR(0x0399))
SELECT @vcResult = REPLACE(@vcResult, 'Κ', NCHAR(0x039a))
SELECT @vcResult = REPLACE(@vcResult, 'Λ', NCHAR(0x039b))
SELECT @vcResult = REPLACE(@vcResult, 'Μ', NCHAR(0x039c))
SELECT @vcResult = REPLACE(@vcResult, 'Ν', NCHAR(0x039d))
SELECT @vcResult = REPLACE(@vcResult, 'Ξ', NCHAR(0x039e))
SELECT @vcResult = REPLACE(@vcResult, 'Ο', NCHAR(0x039f))
SELECT @vcResult = REPLACE(@vcResult, 'Π', NCHAR(0x03a0))
SELECT @vcResult = REPLACE(@vcResult, '& Rho ;', NCHAR(0x03a1))
SELECT @vcResult = REPLACE(@vcResult, 'Σ', NCHAR(0x03a3))
SELECT @vcResult = REPLACE(@vcResult, 'Τ', NCHAR(0x03a4))
SELECT @vcResult = REPLACE(@vcResult, 'Υ', NCHAR(0x03a5))
SELECT @vcResult = REPLACE(@vcResult, 'Φ', NCHAR(0x03a6))
SELECT @vcResult = REPLACE(@vcResult, 'Χ', NCHAR(0x03a7))
SELECT @vcResult = REPLACE(@vcResult, 'Ψ', NCHAR(0x03a8))
SELECT @vcResult = REPLACE(@vcResult, 'Ω', NCHAR(0x03a9))
SELECT @vcResult = REPLACE(@vcResult, 'α', NCHAR(0x03b1))
SELECT @vcResult = REPLACE(@vcResult, 'β', NCHAR(0x03b2))
SELECT @vcResult = REPLACE(@vcResult, 'γ', NCHAR(0x03b3))
SELECT @vcResult = REPLACE(@vcResult, 'δ', NCHAR(0x03b4))
SELECT @vcResult = REPLACE(@vcResult, 'ε', NCHAR(0x03b5))
SELECT @vcResult = REPLACE(@vcResult, 'ζ', NCHAR(0x03b6))
SELECT @vcResult = REPLACE(@vcResult, 'η', NCHAR(0x03b7))
SELECT @vcResult = REPLACE(@vcResult, 'θ', NCHAR(0x03b8))
SELECT @vcResult = REPLACE(@vcResult, 'ι', NCHAR(0x03b9))
SELECT @vcResult = REPLACE(@vcResult, 'κ', NCHAR(0x03ba))
SELECT @vcResult = REPLACE(@vcResult, 'λ', NCHAR(0x03bb))
SELECT @vcResult = REPLACE(@vcResult, 'μ', NCHAR(0x03bc))
SELECT @vcResult = REPLACE(@vcResult, 'ν', NCHAR(0x03bd))
SELECT @vcResult = REPLACE(@vcResult, 'ξ', NCHAR(0x03be))
SELECT @vcResult = REPLACE(@vcResult, 'ο', NCHAR(0x03bf))
SELECT @vcResult = REPLACE(@vcResult, 'π', NCHAR(0x03c0))
SELECT @vcResult = REPLACE(@vcResult, 'ρ', NCHAR(0x03c1))
SELECT @vcResult = REPLACE(@vcResult, '&sigmaf;', NCHAR(0x03c2))
SELECT @vcResult = REPLACE(@vcResult, 'σ', NCHAR(0x03c3))
SELECT @vcResult = REPLACE(@vcResult, 'τ', NCHAR(0x03c4))
SELECT @vcResult = REPLACE(@vcResult, 'υ', NCHAR(0x03c5))
SELECT @vcResult = REPLACE(@vcResult, 'φ', NCHAR(0x03c6))
SELECT @vcResult = REPLACE(@vcResult, 'χ', NCHAR(0x03c7))
SELECT @vcResult = REPLACE(@vcResult, 'ψ', NCHAR(0x03c8))
SELECT @vcResult = REPLACE(@vcResult, 'ω', NCHAR(0x03c9))
SELECT @vcResult = REPLACE(@vcResult, '&thetasym;', NCHAR(0x03d1))
SELECT @vcResult = REPLACE(@vcResult, '&upsih;', NCHAR(0x03d2))
SELECT @vcResult = REPLACE(@vcResult, 'ϖ', NCHAR(0x03d6))
SELECT @vcResult = REPLACE(@vcResult, '&ensp;', NCHAR(0x2002))
SELECT @vcResult = REPLACE(@vcResult, '&emsp;', NCHAR(0x2003))
SELECT @vcResult = REPLACE(@vcResult, ' ', NCHAR(0x2009))
SELECT @vcResult = REPLACE(@vcResult, '&zwnj;', NCHAR(0x200c))
SELECT @vcResult = REPLACE(@vcResult, '&zwj;', NCHAR(0x200d))
SELECT @vcResult = REPLACE(@vcResult, '&lrm;', NCHAR(0x200e))
SELECT @vcResult = REPLACE(@vcResult, '&rlm;', NCHAR(0x200f))
SELECT @vcResult = REPLACE(@vcResult, '–', NCHAR(0x2013))
SELECT @vcResult = REPLACE(@vcResult, '—', NCHAR(0x2014))
SELECT @vcResult = REPLACE(@vcResult, '‘', NCHAR(0x2018))
SELECT @vcResult = REPLACE(@vcResult, '’', NCHAR(0x2019))
SELECT @vcResult = REPLACE(@vcResult, '&sbquo;', NCHAR(0x201a))
SELECT @vcResult = REPLACE(@vcResult, '“', NCHAR(0x201c))
SELECT @vcResult = REPLACE(@vcResult, '”', NCHAR(0x201d))
SELECT @vcResult = REPLACE(@vcResult, '&bdquo;', NCHAR(0x201e))
SELECT @vcResult = REPLACE(@vcResult, '&dagger;', NCHAR(0x2020))
SELECT @vcResult = REPLACE(@vcResult, '&Dagger;', NCHAR(0x2021))
SELECT @vcResult = REPLACE(@vcResult, '•', NCHAR(0x2022))
SELECT @vcResult = REPLACE(@vcResult, '…', NCHAR(0x2026))
SELECT @vcResult = REPLACE(@vcResult, '&permil;', NCHAR(0x2030))
SELECT @vcResult = REPLACE(@vcResult, '′', NCHAR(0x2032))
SELECT @vcResult = REPLACE(@vcResult, '″', NCHAR(0x2033))
SELECT @vcResult = REPLACE(@vcResult, '&lsaquo;', NCHAR(0x2039))
SELECT @vcResult = REPLACE(@vcResult, '&rsaquo;', NCHAR(0x203a))
SELECT @vcResult = REPLACE(@vcResult, '&oline;', NCHAR(0x203e))
SELECT @vcResult = REPLACE(@vcResult, '&frasl;', NCHAR(0x2044))
SELECT @vcResult = REPLACE(@vcResult, '€', NCHAR(0x20ac))
SELECT @vcResult = REPLACE(@vcResult, '&image;', NCHAR(0x2111))
SELECT @vcResult = REPLACE(@vcResult, '&weierp;', NCHAR(0x2118))
SELECT @vcResult = REPLACE(@vcResult, '&real;', NCHAR(0x211c))
SELECT @vcResult = REPLACE(@vcResult, '™', NCHAR(0x2122))
SELECT @vcResult = REPLACE(@vcResult, '&alefsym;', NCHAR(0x2135))
SELECT @vcResult = REPLACE(@vcResult, '←', NCHAR(0x2190))
SELECT @vcResult = REPLACE(@vcResult, '↑', NCHAR(0x2191))
SELECT @vcResult = REPLACE(@vcResult, '→', NCHAR(0x2192))
SELECT @vcResult = REPLACE(@vcResult, '↓', NCHAR(0x2193))
SELECT @vcResult = REPLACE(@vcResult, '↔', NCHAR(0x2194))
SELECT @vcResult = REPLACE(@vcResult, '&crarr;', NCHAR(0x21b5))
SELECT @vcResult = REPLACE(@vcResult, '⇐', NCHAR(0x21d0))
SELECT @vcResult = REPLACE(@vcResult, '&uArr;', NCHAR(0x21d1))
SELECT @vcResult = REPLACE(@vcResult, '⇒', NCHAR(0x21d2))
SELECT @vcResult = REPLACE(@vcResult, '&dArr;', NCHAR(0x21d3))
SELECT @vcResult = REPLACE(@vcResult, '⇔', NCHAR(0x21d4))
SELECT @vcResult = REPLACE(@vcResult, '∀', NCHAR(0x2200))
SELECT @vcResult = REPLACE(@vcResult, '∂', NCHAR(0x2202))
SELECT @vcResult = REPLACE(@vcResult, '∃', NCHAR(0x2203))
SELECT @vcResult = REPLACE(@vcResult, '∅', NCHAR(0x2205))
SELECT @vcResult = REPLACE(@vcResult, '∇', NCHAR(0x2207))
SELECT @vcResult = REPLACE(@vcResult, '∈', NCHAR(0x2208))
SELECT @vcResult = REPLACE(@vcResult, '∉', NCHAR(0x2209))
SELECT @vcResult = REPLACE(@vcResult, '&ni;', NCHAR(0x220b))
SELECT @vcResult = REPLACE(@vcResult, '∏', NCHAR(0x220f))
SELECT @vcResult = REPLACE(@vcResult, '∑', NCHAR(0x2211))
SELECT @vcResult = REPLACE(@vcResult, '−', NCHAR(0x2212))
SELECT @vcResult = REPLACE(@vcResult, '&lowast;', NCHAR(0x2217))
SELECT @vcResult = REPLACE(@vcResult, '√', NCHAR(0x221a))
SELECT @vcResult = REPLACE(@vcResult, '&prop;', NCHAR(0x221d))
SELECT @vcResult = REPLACE(@vcResult, '∞', NCHAR(0x221e))
SELECT @vcResult = REPLACE(@vcResult, '&ang;', NCHAR(0x2220))
SELECT @vcResult = REPLACE(@vcResult, '&and;', NCHAR(0x2227))
SELECT @vcResult = REPLACE(@vcResult, '&or;', NCHAR(0x2228))
SELECT @vcResult = REPLACE(@vcResult, '∩', NCHAR(0x2229))
SELECT @vcResult = REPLACE(@vcResult, '∪', NCHAR(0x222a))
SELECT @vcResult = REPLACE(@vcResult, '∫', NCHAR(0x222b))
SELECT @vcResult = REPLACE(@vcResult, '&there4;', NCHAR(0x2234))
SELECT @vcResult = REPLACE(@vcResult, '&sim;', NCHAR(0x223c))
SELECT @vcResult = REPLACE(@vcResult, '&cong;', NCHAR(0x2245))
SELECT @vcResult = REPLACE(@vcResult, '≈', NCHAR(0x2248))
SELECT @vcResult = REPLACE(@vcResult, '≠', NCHAR(0x2260))
SELECT @vcResult = REPLACE(@vcResult, '&equiv;', NCHAR(0x2261))
SELECT @vcResult = REPLACE(@vcResult, '≤', NCHAR(0x2264))
SELECT @vcResult = REPLACE(@vcResult, '≥', NCHAR(0x2265))
SELECT @vcResult = REPLACE(@vcResult, '⊂', NCHAR(0x2282))
SELECT @vcResult = REPLACE(@vcResult, '⊃', NCHAR(0x2283))
SELECT @vcResult = REPLACE(@vcResult, '&nsub;', NCHAR(0x2284))
SELECT @vcResult = REPLACE(@vcResult, '&sube;', NCHAR(0x2286))
SELECT @vcResult = REPLACE(@vcResult, '&supe;', NCHAR(0x2287))
SELECT @vcResult = REPLACE(@vcResult, '&oplus;', NCHAR(0x2295))
SELECT @vcResult = REPLACE(@vcResult, '&otimes;', NCHAR(0x2297))
SELECT @vcResult = REPLACE(@vcResult, '&perp;', NCHAR(0x22a5))
SELECT @vcResult = REPLACE(@vcResult, '⋅', NCHAR(0x22c5))
SELECT @vcResult = REPLACE(@vcResult, '&lceil;', NCHAR(0x2308))
SELECT @vcResult = REPLACE(@vcResult, '&rceil;', NCHAR(0x2309))
SELECT @vcResult = REPLACE(@vcResult, '&lfloor;', NCHAR(0x230a))
SELECT @vcResult = REPLACE(@vcResult, '&rfloor;', NCHAR(0x230b))
SELECT @vcResult = REPLACE(@vcResult, '&lang;', NCHAR(0x2329))
SELECT @vcResult = REPLACE(@vcResult, '&rang;', NCHAR(0x232a))
SELECT @vcResult = REPLACE(@vcResult, '&loz;', NCHAR(0x25ca))
SELECT @vcResult = REPLACE(@vcResult, '&spades;', NCHAR(0x2660))
SELECT @vcResult = REPLACE(@vcResult, '&clubs;', NCHAR(0x2663))
SELECT @vcResult = REPLACE(@vcResult, '&hearts;', NCHAR(0x2665))
SELECT @vcResult = REPLACE(@vcResult, '&diams;', NCHAR(0x2666))

SELECT @vcResult = REPLACE(@vcResult, '<P>', @vcCrLf)

RETURN @vcResult
END

jhj_hua

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
T-SQL编码函数

用法：SELECT dbo.HTMLDecode(This text contains "encoded" chars ©) 生成：This text contains "encoded" chars ©CREATE FUNCTION HTMLDecode (@InputString NVARCHAR(4000))RETURNS NVARCHAR(4000
复制链接

扫一扫