汉字符号过滤函数-白红宇

汉字符号过滤函数
阅读量：6509 次
发布时间：2019-06-24
本文共 17233 字，大约阅读时间需要 57 分钟。
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 @TargetString225 END
View Code
转载于:https://www.cnblogs.com/RocCnBlog/p/5088769.html
你可能感兴趣的文章
JAVA 8 特性
查看>>
算法设计 - LCS 最长公共子序列&&最长公共子串 &&LIS 最长递增子序列
查看>>
WebService之Axis2快速入门(7): Spring与axis整合发布为WebServic