• 汉字符号过滤函数

      1 Create FUNCTION [dbo].[MarkRemoveFunction] 
  2 (
  3     @TargetString varchar(max)
  4 )
  5 RETURNS varchar(max)
  6 AS
  7 BEGIN
  8     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'!','')
  9     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'"','')
 10     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'#','')
 11     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'$','')
 12     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'%','')
 13     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'&','')
 14     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'''','')
 15     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'(','')
 16     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,')','')
 17     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'*','')
 18     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'+','')
 19     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,',','')
 20     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'-','')
 21     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'.','')
 22     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,':','')
 23     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,';','')
 24     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'<','')
 25     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'=','')
 26     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'>','')
 27     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'@','')
 28     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'[','')
 29     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'','')
 30     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,']','')
 31     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'^','')
 32     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'_','')
 33     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'`','')
 34     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'{','')
 35     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'|','')
 36     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'}','')
 37     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'~','')
 38     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'｡','')
 39     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'｢','')
 40     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'｣','')
 41     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'､','')
 42     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'･','')
 43     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'ﾞ','')  
 44     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'ﾟ','')  
 45     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'、','')
 46     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'。','')
 47     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'，','')
 48     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'．','')
 49     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'・','')
 50     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'：','')
 51     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'；','')
 52     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'？','')
 53     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'！','')
 54     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'゛','')  
 55     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'゜','')  
 56     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'´','')
 57     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'｀','')
 58     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'¨','')
 59     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'＾','')
 60     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'￣','')
 61     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'＿','')
 62     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'ヽ','')
 63     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'ヾ','')
 64     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'ゝ','')
 65     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'ゞ','')
 66     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'〃','')
 67     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'仝','')
 68     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'々','')
 69     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'〆','')
 70     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'〇','') 
 71     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'ー','')  
 72     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'―','')
 73     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'‐','')
 74     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'／','')
 75     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'＼','')
 76     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'～','')
 77     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'∥','')
 78     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'｜','')
 79     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'…','')
 80     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'‥','')
 81     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'‘','')
 82     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'’','')
 83     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'“','')
 84     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'”','')
 85     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'（','')
 86     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'）','')
 87     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'〔','')
 88     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'〕','')
 89     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'［','')
 90     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'］','')
 91     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'｛','')
 92     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'｝','')
 93     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'〈','')
 94     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'〉','')
 95     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'《','')
 96     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'》','')
 97     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'「','')
 98     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'」','')
 99     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'『','')
100     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'』','')
101     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'【','')
102     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'】','')
103     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'＋','')
104     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'－','')
105     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'±','')
106     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'×','')
107     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'÷','')
108     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'＝','')
109     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'≠','')
110     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'＜','')
111     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'＞','')
112     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'≦','')
113     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'≧','')
114     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'∞','')
115     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'∴','')
116     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'♂','')
117     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'♀','')
118     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'°','')
119     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'′','')
120     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'″','')
121     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'℃','')
122     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'￥','')
123     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'＄','')
124     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'￠','')
125     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'￡','')
126     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'％','')
127     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'＃','')
128     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'＆','')
129     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'＊','')
130     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'＠','')
131     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'§','')
132     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'☆','')
133     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'★','')
134     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'○','')
135     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'●','')
136     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'◎','')
137     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'◇','')
138     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'◆','')
139     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'□','')
140     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'■','')
141     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'△','')
142     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'▲','')
143     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'▽','')
144     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'▼','')
145     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'※','')
146     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'〒','')
147     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'→','')
148     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'←','')
149     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'↑','')
150     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'↓','')
151     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'〓','')
152     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'∈','')
153     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'∋','')
154     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'⊆','')
155     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'⊇','')
156     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'⊂','')
157     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'⊃','')
158     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'∪','')
159     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'∩','')
160     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'∧','')
161     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'∨','')
162     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'￢','')
163     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'⇒','')
164     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'⇔','')
165     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'∀','')
166     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'∃','')
167     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'∠','')
168     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'⊥','')
169     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'⌒','')
170     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'∂','')
171     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'∇','')
172     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'≡','')
173     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'≒','')
174     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'≪','')
175     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'≫','')
176     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'√','')
177     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'∽','')
178     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'∝','')
179     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'∵','')
180     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'∫','')
181     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'∬','')
182     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'Å','')
183     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'‰','')
184     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'＃','')
185     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'♭','')
186     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'♪','')
187     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'†','')
188     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'‡','')
189     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'','')
190     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'◯','')
191     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'─','')
192     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'│','')
193     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┌','')
194     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┐','')
195     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┘','')
196     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'└','')
197     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'├','')
198     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┬','')
199     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┤','')
200     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┴','')
201     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┼','')
202     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'━','')
203     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┃','')
204     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┏','')
205     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┓','')
206     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┛','')
207     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┗','')
208     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┣','')
209     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┳','')
210     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┫','')
211     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┻','')
212     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'╋','')
213     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┠','')
214     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┯','')
215     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┨','')
216     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┷','')
217     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┿','')
218     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┝','')
219     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┰','')
220     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┥','')
221     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'┸','')
222     SET @TargetString = REPLACE(@TargetString collate Japanese_BIN2,'╂','')
223 
224     RETURN @TargetString
225 END
    View Code
  • 相关阅读:
    实现用户密码登录
    面对不同类型老板，你该怎么办？
    11 款最好 CSS 框架 让你的网站独领风骚
    C#程序开发中经常遇到的10条实用的代码
    linux之Unable to find the ncurses libraries or the required header files.错误解决办法
    55+手绘网站设计 – 构建极具创新效果的网站
    超棒的JS移动设备滑动内容幻灯实现
    15个非常棒的jQuery无限滚动插件【瀑布流效果】
    前端性能优化：DocumentFragments或innerHTML取代复杂的元素注入
    TopFreeTheme精选免费模板【20130619】
  • 原文地址：https://www.cnblogs.com/RocCnBlog/p/5088769.html
Copyright © 2020-2023  润新知