T-SQL编码函数
来源:互联网 发布:java换ip刷页面访问量 编辑:程序博客网 时间:2024/06/06 02:31
用法:SELECT dbo.HTMLDecode('This text contains "encoded" chars ©')
生成:This text contains "encoded" chars ©
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, 'Œ', NCHAR(0x0152))
SELECT @vcResult = REPLACE(@vcResult, 'œ', NCHAR(0x0153))
SELECT @vcResult = REPLACE(@vcResult, 'Š', NCHAR(0x0160))
SELECT @vcResult = REPLACE(@vcResult, 'š', NCHAR(0x0161))
SELECT @vcResult = REPLACE(@vcResult, 'Ÿ', NCHAR(0x0178))
SELECT @vcResult = REPLACE(@vcResult, 'ƒ', NCHAR(0x0192))
SELECT @vcResult = REPLACE(@vcResult, 'ˆ', NCHAR(0x02c6))
SELECT @vcResult = REPLACE(@vcResult, '˜', 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, 'ς', 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, 'ϑ', NCHAR(0x03d1))
SELECT @vcResult = REPLACE(@vcResult, 'ϒ', NCHAR(0x03d2))
SELECT @vcResult = REPLACE(@vcResult, 'ϖ', NCHAR(0x03d6))
SELECT @vcResult = REPLACE(@vcResult, ' ', NCHAR(0x2002))
SELECT @vcResult = REPLACE(@vcResult, ' ', NCHAR(0x2003))
SELECT @vcResult = REPLACE(@vcResult, ' ', NCHAR(0x2009))
SELECT @vcResult = REPLACE(@vcResult, '‌', NCHAR(0x200c))
SELECT @vcResult = REPLACE(@vcResult, '‍', NCHAR(0x200d))
SELECT @vcResult = REPLACE(@vcResult, '‎', NCHAR(0x200e))
SELECT @vcResult = REPLACE(@vcResult, '‏', 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, '‚', NCHAR(0x201a))
SELECT @vcResult = REPLACE(@vcResult, '“', NCHAR(0x201c))
SELECT @vcResult = REPLACE(@vcResult, '”', NCHAR(0x201d))
SELECT @vcResult = REPLACE(@vcResult, '„', NCHAR(0x201e))
SELECT @vcResult = REPLACE(@vcResult, '†', NCHAR(0x2020))
SELECT @vcResult = REPLACE(@vcResult, '‡', NCHAR(0x2021))
SELECT @vcResult = REPLACE(@vcResult, '•', NCHAR(0x2022))
SELECT @vcResult = REPLACE(@vcResult, '…', NCHAR(0x2026))
SELECT @vcResult = REPLACE(@vcResult, '‰', NCHAR(0x2030))
SELECT @vcResult = REPLACE(@vcResult, '′', NCHAR(0x2032))
SELECT @vcResult = REPLACE(@vcResult, '″', NCHAR(0x2033))
SELECT @vcResult = REPLACE(@vcResult, '‹', NCHAR(0x2039))
SELECT @vcResult = REPLACE(@vcResult, '›', NCHAR(0x203a))
SELECT @vcResult = REPLACE(@vcResult, '‾', NCHAR(0x203e))
SELECT @vcResult = REPLACE(@vcResult, '⁄', NCHAR(0x2044))
SELECT @vcResult = REPLACE(@vcResult, '€', NCHAR(0x20ac))
SELECT @vcResult = REPLACE(@vcResult, 'ℑ', NCHAR(0x2111))
SELECT @vcResult = REPLACE(@vcResult, '℘', NCHAR(0x2118))
SELECT @vcResult = REPLACE(@vcResult, 'ℜ', NCHAR(0x211c))
SELECT @vcResult = REPLACE(@vcResult, '™', NCHAR(0x2122))
SELECT @vcResult = REPLACE(@vcResult, 'ℵ', 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, '↵', NCHAR(0x21b5))
SELECT @vcResult = REPLACE(@vcResult, '⇐', NCHAR(0x21d0))
SELECT @vcResult = REPLACE(@vcResult, '⇑', NCHAR(0x21d1))
SELECT @vcResult = REPLACE(@vcResult, '⇒', NCHAR(0x21d2))
SELECT @vcResult = REPLACE(@vcResult, '⇓', 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, '∋', NCHAR(0x220b))
SELECT @vcResult = REPLACE(@vcResult, '∏', NCHAR(0x220f))
SELECT @vcResult = REPLACE(@vcResult, '∑', NCHAR(0x2211))
SELECT @vcResult = REPLACE(@vcResult, '−', NCHAR(0x2212))
SELECT @vcResult = REPLACE(@vcResult, '∗', NCHAR(0x2217))
SELECT @vcResult = REPLACE(@vcResult, '√', NCHAR(0x221a))
SELECT @vcResult = REPLACE(@vcResult, '∝', NCHAR(0x221d))
SELECT @vcResult = REPLACE(@vcResult, '∞', NCHAR(0x221e))
SELECT @vcResult = REPLACE(@vcResult, '∠', NCHAR(0x2220))
SELECT @vcResult = REPLACE(@vcResult, '∧', NCHAR(0x2227))
SELECT @vcResult = REPLACE(@vcResult, '∨', NCHAR(0x2228))
SELECT @vcResult = REPLACE(@vcResult, '∩', NCHAR(0x2229))
SELECT @vcResult = REPLACE(@vcResult, '∪', NCHAR(0x222a))
SELECT @vcResult = REPLACE(@vcResult, '∫', NCHAR(0x222b))
SELECT @vcResult = REPLACE(@vcResult, '∴', NCHAR(0x2234))
SELECT @vcResult = REPLACE(@vcResult, '∼', NCHAR(0x223c))
SELECT @vcResult = REPLACE(@vcResult, '≅', NCHAR(0x2245))
SELECT @vcResult = REPLACE(@vcResult, '≈', NCHAR(0x2248))
SELECT @vcResult = REPLACE(@vcResult, '≠', NCHAR(0x2260))
SELECT @vcResult = REPLACE(@vcResult, '≡', 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, '⊄', NCHAR(0x2284))
SELECT @vcResult = REPLACE(@vcResult, '⊆', NCHAR(0x2286))
SELECT @vcResult = REPLACE(@vcResult, '⊇', NCHAR(0x2287))
SELECT @vcResult = REPLACE(@vcResult, '⊕', NCHAR(0x2295))
SELECT @vcResult = REPLACE(@vcResult, '⊗', NCHAR(0x2297))
SELECT @vcResult = REPLACE(@vcResult, '⊥', NCHAR(0x22a5))
SELECT @vcResult = REPLACE(@vcResult, '⋅', NCHAR(0x22c5))
SELECT @vcResult = REPLACE(@vcResult, '⌈', NCHAR(0x2308))
SELECT @vcResult = REPLACE(@vcResult, '⌉', NCHAR(0x2309))
SELECT @vcResult = REPLACE(@vcResult, '⌊', NCHAR(0x230a))
SELECT @vcResult = REPLACE(@vcResult, '⌋', NCHAR(0x230b))
SELECT @vcResult = REPLACE(@vcResult, '⟨', NCHAR(0x2329))
SELECT @vcResult = REPLACE(@vcResult, '⟩', NCHAR(0x232a))
SELECT @vcResult = REPLACE(@vcResult, '◊', NCHAR(0x25ca))
SELECT @vcResult = REPLACE(@vcResult, '♠', NCHAR(0x2660))
SELECT @vcResult = REPLACE(@vcResult, '♣', NCHAR(0x2663))
SELECT @vcResult = REPLACE(@vcResult, '♥', NCHAR(0x2665))
SELECT @vcResult = REPLACE(@vcResult, '♦', NCHAR(0x2666))
SELECT @vcResult = REPLACE(@vcResult, '<P>', @vcCrLf)
RETURN @vcResult
END
- T-SQL编码函数
- T-SQL 编码标准
- T-SQL 编码标准
- T-SQL 编码标准
- T-SQL 编码标准
- T-SQL 编码标准
- T-SQL 编码标准
- T-SQL 编码标准
- T-SQL 编码标准
- T-SQL 编码标准
- T-SQL 编码标准
- T-SQL 编码标准
- T-SQL 编码标准
- T-SQL 编码标准
- T-sql 函数
- T-Sql函数
- T-sql函数
- T-SQL 函数记录
- Asp.net 2.0
- c++实现系统托盘图标
- c++继承关系
- Java Language Keywords
- ASP.NET的HTMLTable原样导出到Excel
- T-SQL编码函数
- IIS不能运行ASP的解决方法
- linux服务器深度历险之调试工具
- C语言之可变参数问题
- Linux内存管理——vmstat
- Linux操作系统Vmstat命令列出的属性详解
- YouMonitor.Us功能FAQ
- ASP.NET的环境安装
- Linux操作系统Vmstat命令列出的属性详解