SQL 根据汉字获取全拼

  1 /*
  2  SQL 根据汉字获取全拼（有些字还没有添加上去，请自已加上去，涂聚文注）
  3  1.生成所有读音临时表
  4  2.根据Chinese_PRC_CS_AS_KS_WS 排序获取读音
  5  3.geovindu@163.com  2009-12-2 其它功能請商討，我是在繁體的環境測試，簡體會更方便一些。
  6 */
  7 if exists(select 1 from sysobjects where name = 'f_GetPy' and xtype = 'FN')
  8 drop function f_GetPy
  9 go
 10 CREATE function f_GetPy(@str varchar(100))
 11 returns varchar(8000)
 12 as
 13 begin
 14  declare @re varchar(8000)
 15  --生成临时表
 16  --geovindu@163.com    www.dusystem.com www.dupcit.com
 17  declare @geovindu table(chr nchar(2) collate  Chinese_PRC_CS_AS_KS_WS,py nvarchar(20)) 
 18  insert into @geovindu select N'吖','a' 
 19  insert into @geovindu select N'厑','aes' 
 20  insert into @geovindu select N'哎','ai' 
 21  insert into @geovindu select N'安','an' 
 22  insert into @geovindu select N'肮','ang' 
 23  insert into @geovindu select N'凹','ao' 
 24  insert into @geovindu select N'八','ba' 
 25  insert into @geovindu select N'挀','bai' 
 26  insert into @geovindu select N'兡','baike' 
 27  insert into @geovindu select N'瓸','baiwa' 
 28  insert into @geovindu select N'扳','ban' 
 29  insert into @geovindu select N'邦','bang' 
 30  insert into @geovindu select N'勹','bao' 
 31  insert into @geovindu select N'萡','be' 
 32  insert into @geovindu select N'陂','bei' 
 33  insert into @geovindu select N'奔','ben' 
 34  insert into @geovindu select N'伻','beng' 
 35  insert into @geovindu select N'皀','bi' 
 36  insert into @geovindu select N'边','bian' 
 37  insert into @geovindu select N'辪','uu' 
 38  insert into @geovindu select N'灬','biao' 
 39  insert into @geovindu select N'憋','bie' 
 40  insert into @geovindu select N'汃','bin' 
 41  insert into @geovindu select N'冫','bing' 
 42  insert into @geovindu select N'癶','bo' 
 43  insert into @geovindu select N'峬','bu' 
 44  insert into @geovindu select N'嚓','ca' 
 45  insert into @geovindu select N'偲','cai' 
 46  insert into @geovindu select N'乲','cal' 
 47  insert into @geovindu select N'参','can' 
 48  insert into @geovindu select N'仓','cang' 
 49  insert into @geovindu select N'撡','cao' 
 50  insert into @geovindu select N'冊','ce' 
 51  insert into @geovindu select N'膥','cen' 
 52  insert into @geovindu select N'噌','ceng' 
 53  insert into @geovindu select N'硛','ceok' 
 54  insert into @geovindu select N'岾','ceom' 
 55  insert into @geovindu select N'猠','ceon' 
 56  insert into @geovindu select N'乽','ceor' 
 57  insert into @geovindu select N'叉','cha' 
 58  insert into @geovindu select N'犲','chai' 
 59  insert into @geovindu select N'辿','chan' 
 60  insert into @geovindu select N'伥','chang' 
 61  insert into @geovindu select N'抄','chao' 
 62  insert into @geovindu select N'车','che' 
 63  insert into @geovindu select N'抻','chen' 
 64  insert into @geovindu select N'阷','cheng' 
 65  insert into @geovindu select N'吃','chi' 
 66  insert into @geovindu select N'充','chong' 
 67  insert into @geovindu select N'抽','chou' 
 68  insert into @geovindu select N'出','chu' 
 69  insert into @geovindu select N'膗','chuai' 
 70  insert into @geovindu select N'巛','chuan' 
 71  insert into @geovindu select N'刅','chuang' 
 72  insert into @geovindu select N'吹','chui' 
 73  insert into @geovindu select N'旾','chun' 
 74  insert into @geovindu select N'踔','chuo' 
 75  insert into @geovindu select N'呲','ci' 
 76  insert into @geovindu select N'嗭','cis' 
 77  insert into @geovindu select N'从','cong' 
 78  insert into @geovindu select N'凑','cou' 
 79  insert into @geovindu select N'粗','cu' 
 80  insert into @geovindu select N'汆','cuan' 
 81  insert into @geovindu select N'崔','cui' 
 82  insert into @geovindu select N'邨','cun' 
 83  insert into @geovindu select N'瑳','cuo' 
 84  insert into @geovindu select N'撮','chua' 
 85  insert into @geovindu select N'咑','da' 
 86  insert into @geovindu select N'呔','dai' 
 87  insert into @geovindu select N'丹','dan' 
 88  insert into @geovindu select N'当','dang' 
 89  insert into @geovindu select N'刀','dao' 
 90  insert into @geovindu select N'恴','de' 
 91  insert into @geovindu select N'揼','dem' 
 92  insert into @geovindu select N'扥','den' 
 93  insert into @geovindu select N'灯','deng' 
 94  insert into @geovindu select N'仾','di' 
 95  insert into @geovindu select N'嗲','dia' 
 96  insert into @geovindu select N'敁','dian' 
 97  insert into @geovindu select N'刁','diao' 
 98  insert into @geovindu select N'爹','die' 
 99  insert into @geovindu select N'哋','dei' 
100  insert into @geovindu select N'嚸','dim' 
101  insert into @geovindu select N'丁','ding' 
102  insert into @geovindu select N'丟','diu' 
103  insert into @geovindu select N'东','dong' 
104  insert into @geovindu select N'吺','dou' 
105  insert into @geovindu select N'剢','du' 
106  insert into @geovindu select N'耑','duan' 
107  insert into @geovindu select N'叾','dug' 
108  insert into @geovindu select N'垖','dui' 
109  insert into @geovindu select N'吨','dun' 
110  insert into @geovindu select N'咄','duo' 
111  insert into @geovindu select N'妸','e' 
112  insert into @geovindu select N'奀','en' 
113  insert into @geovindu select N'鞥','eng' 
114  insert into @geovindu select N'仒','eo' 
115  insert into @geovindu select N'乻','eol' 
116  insert into @geovindu select N'旕','eos' 
117  insert into @geovindu select N'儿','er' 
118  insert into @geovindu select N'发','fa' 
119  insert into @geovindu select N'帆','fan' 
120  insert into @geovindu select N'匚','fang' 
121  insert into @geovindu select N'飞','fei' 
122  insert into @geovindu select N'吩','fen' 
123  insert into @geovindu select N'丰','feng' 
124  insert into @geovindu select N'瓰','fenwa' 
125  insert into @geovindu select N'覅','fiao' 
126  insert into @geovindu select N'仏','fo' 
127  insert into @geovindu select N'垺','fou' 
128  insert into @geovindu select N'夫','fu' 
129  insert into @geovindu select N'猤','fui' 
130  insert into @geovindu select N'旮','ga' 
131  insert into @geovindu select N'侅','gai' 
132  insert into @geovindu select N'甘','gan' 
133  insert into @geovindu select N'冈','gang' 
134  insert into @geovindu select N'皋','gao' 
135  insert into @geovindu select N'戈','ge' 
136  insert into @geovindu select N'给','gei' 
137  insert into @geovindu select N'根','gen' 
138  insert into @geovindu select N'更','geng' 
139  insert into @geovindu select N'啹','geu' 
140  insert into @geovindu select N'喼','gib' 
141  insert into @geovindu select N'嗰','go' 
142  insert into @geovindu select N'工','gong' 
143  insert into @geovindu select N'兝','gongfen' 
144  insert into @geovindu select N'兣','gongli' 
145  insert into @geovindu select N'勾','gou' 
146  insert into @geovindu select N'估','gu' 
147  insert into @geovindu select N'瓜','gua' 
148  insert into @geovindu select N'乖','guai' 
149  insert into @geovindu select N'关','guan' 
150  insert into @geovindu select N'光','guang' 
151  insert into @geovindu select N'归','gui' 
152  insert into @geovindu select N'丨','gun' 
153  insert into @geovindu select N'呙','guo' 
154  insert into @geovindu select N'妎','ha' 
155  insert into @geovindu select N'咍','hai' 
156  insert into @geovindu select N'乤','hal' 
157  insert into @geovindu select N'兯','han' 
158  insert into @geovindu select N'魧','hang' 
159  insert into @geovindu select N'茠','hao' 
160  insert into @geovindu select N'兞','haoke' 
161  insert into @geovindu select N'诃','he' 
162  insert into @geovindu select N'黒','hei' 
163  insert into @geovindu select N'拫','hen' 
164  insert into @geovindu select N'亨','heng' 
165  insert into @geovindu select N'囍','heui' 
166  insert into @geovindu select N'乊','ho' 
167  insert into @geovindu select N'乥','hol' 
168  insert into @geovindu select N'叿','hong' 
169  insert into @geovindu select N'齁','hou' 
170  insert into @geovindu select N'乎','hu' 
171  insert into @geovindu select N'花','hua' 
172  insert into @geovindu select N'徊','huai' 
173  insert into @geovindu select N'欢','huan' 
174  insert into @geovindu select N'巟','huang' 
175  insert into @geovindu select N'灰','hui' 
176  insert into @geovindu select N'昏','hun' 
177  insert into @geovindu select N'吙','huo' 
178  insert into @geovindu select N'嚿','geo' 
179  insert into @geovindu select N'夻','hwa' 
180  insert into @geovindu select N'丌','ji' 
181  insert into @geovindu select N'加','jia' 
182  insert into @geovindu select N'嗧','jialun' 
183  insert into @geovindu select N'戋','jian' 
184  insert into @geovindu select N'江','jiang' 
185  insert into @geovindu select N'艽','jiao' 
186  insert into @geovindu select N'阶','jie' 
187  insert into @geovindu select N'巾','jin' 
188  insert into @geovindu select N'坕','jing' 
189  insert into @geovindu select N'冂','jiong' 
190  insert into @geovindu select N'丩','jiu' 
191  insert into @geovindu select N'欍','jou' 
192  insert into @geovindu select N'凥','ju' 
193  insert into @geovindu select N'姢','juan' 
194  insert into @geovindu select N'噘','jue' 
195  insert into @geovindu select N'军','jun' 
196  insert into @geovindu select N'咔','ka' 
197  insert into @geovindu select N'开','kai' 
198  insert into @geovindu select N'乫','kal' 
199  insert into @geovindu select N'刊','kan' 
200  insert into @geovindu select N'冚','hem' 
201  insert into @geovindu select N'砊','kang' 
202  insert into @geovindu select N'尻','kao' 
203  insert into @geovindu select N'坷','ke' 
204  insert into @geovindu select N'肎','ken' 
205  insert into @geovindu select N'劥','keng' 
206  insert into @geovindu select N'巪','keo' 
207  insert into @geovindu select N'乬','keol' 
208  insert into @geovindu select N'唟','keos' 
209  insert into @geovindu select N'厼','keum' 
210  insert into @geovindu select N'怾','ki' 
211  insert into @geovindu select N'空','kong' 
212  insert into @geovindu select N'廤','kos' 
213  insert into @geovindu select N'抠','kou' 
214  insert into @geovindu select N'扝','ku' 
215  insert into @geovindu select N'夸','kua' 
216  insert into @geovindu select N'蒯','kuai' 
217  insert into @geovindu select N'宽','kuan' 
218  insert into @geovindu select N'匡','kuang' 
219  insert into @geovindu select N'亏','kui' 
220  insert into @geovindu select N'坤','kun' 
221  insert into @geovindu select N'拡','kuo' 
222  insert into @geovindu select N'穒','kweok' 
223  insert into @geovindu select N'垃','la' 
224  insert into @geovindu select N'来','lai' 
225  insert into @geovindu select N'兰','lan' 
226  insert into @geovindu select N'啷','lang' 
227  insert into @geovindu select N'捞','lao' 
228  insert into @geovindu select N'仂','le' 
229  insert into @geovindu select N'雷','lei' 
230  insert into @geovindu select N'塄','leng' 
231  insert into @geovindu select N'唎','li' 
232  insert into @geovindu select N'俩','lia' 
233  insert into @geovindu select N'嫾','lian' 
234  insert into @geovindu select N'簗','liang' 
235  insert into @geovindu select N'蹽','liao' 
236  insert into @geovindu select N'毟','lie' 
237  insert into @geovindu select N'厸','lin' 
238  insert into @geovindu select N'伶','ling' 
239  insert into @geovindu select N'溜','liu' 
240  insert into @geovindu select N'瓼','liwa' 
241  insert into @geovindu select N'囖','lo' 
242  insert into @geovindu select N'龙','long' 
243  insert into @geovindu select N'娄','lou' 
244  insert into @geovindu select N'噜','lu' 
245  insert into @geovindu select N'驴','lv' 
246  insert into @geovindu select N'寽','lue' 
247  insert into @geovindu select N'孪','luan' 
248  insert into @geovindu select N'掄','lun' 
249  insert into @geovindu select N'頱','luo' 
250  insert into @geovindu select N'呣','m' 
251  insert into @geovindu select N'妈','ma' 
252  insert into @geovindu select N'遤','hweong' 
253  insert into @geovindu select N'埋','mai' 
254  insert into @geovindu select N'颟','man' 
255  insert into @geovindu select N'牤','mang' 
256  insert into @geovindu select N'匁','mangmi' 
257  insert into @geovindu select N'猫','mao' 
258  insert into @geovindu select N'唜','mas' 
259  insert into @geovindu select N'庅','me' 
260  insert into @geovindu select N'呅','mei' 
261  insert into @geovindu select N'椚','men' 
262  insert into @geovindu select N'掹','meng' 
263  insert into @geovindu select N'踎','meo' 
264  insert into @geovindu select N'瞇','mi' 
265  insert into @geovindu select N'宀','mian' 
266  insert into @geovindu select N'喵','miao' 
267  insert into @geovindu select N'乜','mie' 
268  insert into @geovindu select N'瓱','miliklanm' 
269  insert into @geovindu select N'民','min' 
270  insert into @geovindu select N'冧','lem' 
271  insert into @geovindu select N'名','ming' 
272  insert into @geovindu select N'谬','miu' 
273  insert into @geovindu select N'摸','mo' 
274  insert into @geovindu select N'乮','mol' 
275  insert into @geovindu select N'哞','mou' 
276  insert into @geovindu select N'母','mu' 
277  insert into @geovindu select N'旀','myeo' 
278  insert into @geovindu select N'丆','myeon' 
279  insert into @geovindu select N'椧','myeong' 
280  insert into @geovindu select N'拏','na' 
281  insert into @geovindu select N'腉','nai' 
282  insert into @geovindu select N'囡','nan' 
283  insert into @geovindu select N'囔','nang' 
284  insert into @geovindu select N'乪','keg' 
285  insert into @geovindu select N'孬','nao' 
286  insert into @geovindu select N'疒','ne' 
287  insert into @geovindu select N'娞','nei' 
288  insert into @geovindu select N'焾','nem' 
289  insert into @geovindu select N'嫩','nen' 
290  insert into @geovindu select N'莻','neus' 
291  insert into @geovindu select N'鈪','ngag' 
292  insert into @geovindu select N'銰','ngai' 
293  insert into @geovindu select N'啱','ngam' 
294  insert into @geovindu select N'妮','ni' 
295  insert into @geovindu select N'年','nian' 
296  insert into @geovindu select N'娘','niang' 
297  insert into @geovindu select N'茑','niao' 
298  insert into @geovindu select N'捏','nie' 
299  insert into @geovindu select N'脌','nin' 
300  insert into @geovindu select N'宁','ning' 
301  insert into @geovindu select N'牛','niu' 
302  insert into @geovindu select N'农','nong' 
303  insert into @geovindu select N'羺','nou' 
304  insert into @geovindu select N'奴','nu' 
305  insert into @geovindu select N'女','nv' 
306  insert into @geovindu select N'疟','nue' 
307  insert into @geovindu select N'瘧','nve' 
308  insert into @geovindu select N'奻','nuan' 
309  insert into @geovindu select N'黁','nun' 
310  insert into @geovindu select N'燶','nung' 
311  insert into @geovindu select N'挪','nuo' 
312  insert into @geovindu select N'筽','o' 
313  insert into @geovindu select N'夞','oes' 
314  insert into @geovindu select N'乯','ol' 
315  insert into @geovindu select N'鞰','on' 
316  insert into @geovindu select N'讴','ou' 
317  insert into @geovindu select N'妑','pa' 
318  insert into @geovindu select N'俳','pai' 
319  insert into @geovindu select N'磗','pak' 
320  insert into @geovindu select N'眅','pan' 
321  insert into @geovindu select N'乓','pang' 
322  insert into @geovindu select N'抛','pao' 
323  insert into @geovindu select N'呸','pei' 
324  insert into @geovindu select N'瓫','pen' 
325  insert into @geovindu select N'匉','peng' 
326  insert into @geovindu select N'浌','peol' 
327  insert into @geovindu select N'巼','phas' 
328  insert into @geovindu select N'闏','phdeng' 
329  insert into @geovindu select N'乶','phoi' 
330  insert into @geovindu select N'喸','phos' 
331  insert into @geovindu select N'丕','pi' 
332  insert into @geovindu select N'囨','pian' 
333  insert into @geovindu select N'缥','piao' 
334  insert into @geovindu select N'氕','pie' 
335  insert into @geovindu select N'丿','pianpang' 
336  insert into @geovindu select N'姘','pin' 
337  insert into @geovindu select N'乒','ping' 
338  insert into @geovindu select N'钋','po' 
339  insert into @geovindu select N'剖','pou' 
340  insert into @geovindu select N'哣','deo' 
341  insert into @geovindu select N'兺','ppun' 
342  insert into @geovindu select N'仆','pu' 
343  insert into @geovindu select N'七','qi' 
344  insert into @geovindu select N'掐','qia' 
345  insert into @geovindu select N'千','qian' 
346  insert into @geovindu select N'羌','qiang' 
347  insert into @geovindu select N'兛','qianke' 
348  insert into @geovindu select N'瓩','qianwa' 
349  insert into @geovindu select N'悄','qiao' 
350  insert into @geovindu select N'苆','qie' 
351  insert into @geovindu select N'亲','qin' 
352  insert into @geovindu select N'蠄','kem' 
353  insert into @geovindu select N'氢','qing' 
354  insert into @geovindu select N'銎','qiong' 
355  insert into @geovindu select N'丘','qiu' 
356  insert into @geovindu select N'曲','qu' 
357  insert into @geovindu select N'迲','keop' 
358  insert into @geovindu select N'峑','quan' 
359  insert into @geovindu select N'蒛','que' 
360  insert into @geovindu select N'夋','qun' 
361  insert into @geovindu select N'亽','ra' 
362  insert into @geovindu select N'囕','ram' 
363  insert into @geovindu select N'呥','ran' 
364  insert into @geovindu select N'穣','rang' 
365  insert into @geovindu select N'荛','rao' 
366  insert into @geovindu select N'惹','re' 
367  insert into @geovindu select N'人','ren' 
368  insert into @geovindu select N'扔','reng' 
369  insert into @geovindu select N'日','ri' 
370  insert into @geovindu select N'栄','rong' 
371  insert into @geovindu select N'禸','rou' 
372  insert into @geovindu select N'嶿','ru' 
373  insert into @geovindu select N'撋','ruan' 
374  insert into @geovindu select N'桵','rui' 
375  insert into @geovindu select N'闰','run' 
376  insert into @geovindu select N'叒','ruo' 
377  insert into @geovindu select N'仨','sa' 
378  insert into @geovindu select N'栍','saeng' 
379  insert into @geovindu select N'毢','sai' 
380  insert into @geovindu select N'虄','sal' 
381  insert into @geovindu select N'三','san' 
382  insert into @geovindu select N'桒','sang' 
383  insert into @geovindu select N'掻','sao' 
384  insert into @geovindu select N'色','se' 
385  insert into @geovindu select N'裇','sed' 
386  insert into @geovindu select N'聓','sei' 
387  insert into @geovindu select N'森','sen' 
388  insert into @geovindu select N'鬙','seng' 
389  insert into @geovindu select N'閪','seo' 
390  insert into @geovindu select N'縇','seon' 
391  insert into @geovindu select N'杀','sha' 
392  insert into @geovindu select N'筛','shai' 
393  insert into @geovindu select N'山','shan' 
394  insert into @geovindu select N'伤','shang' 
395  insert into @geovindu select N'弰','shao' 
396  insert into @geovindu select N'奢','she' 
397  insert into @geovindu select N'申','shen' 
398  insert into @geovindu select N'升','sheng' 
399  insert into @geovindu select N'尸','shi' 
400  insert into @geovindu select N'兙','shike' 
401  insert into @geovindu select N'瓧','shiwa' 
402  insert into @geovindu select N'収','shou' 
403  insert into @geovindu select N'书','shu' 
404  insert into @geovindu select N'刷','shua' 
405  insert into @geovindu select N'摔','shuai' 
406  insert into @geovindu select N'闩','shuan' 
407  insert into @geovindu select N'双','shuang' 
408  insert into @geovindu select N'谁','shei' 
409  insert into @geovindu select N'脽','shui' 
410  insert into @geovindu select N'吮','shun' 
411  insert into @geovindu select N'哾','shuo' 
412  insert into @geovindu select N'丝','si' 
413  insert into @geovindu select N'螦','so' 
414  insert into @geovindu select N'乺','sol' 
415  insert into @geovindu select N'忪','song' 
416  insert into @geovindu select N'凁','sou' 
417  insert into @geovindu select N'苏','su' 
418  insert into @geovindu select N'痠','suan' 
419  insert into @geovindu select N'夊','sui'
420  insert into @geovindu select N'娑','suo' 
421  insert into @geovindu select N'他','ta' 
422  insert into @geovindu select N'襨','tae' 
423  insert into @geovindu select N'囼','tai' 
424  insert into @geovindu select N'坍','tan' 
425  insert into @geovindu select N'铴','tang' 
426  insert into @geovindu select N'仐','tao' 
427  insert into @geovindu select N'畓','tap' 
428  insert into @geovindu select N'忒','te' 
429  insert into @geovindu select N'膯','teng' 
430  insert into @geovindu select N'唞','teo' 
431  insert into @geovindu select N'朰','teul' 
432  insert into @geovindu select N'剔','ti' 
433  insert into @geovindu select N'天','tian' 
434  insert into @geovindu select N'旫','tiao' 
435  insert into @geovindu select N'怗','tie' 
436  insert into @geovindu select N'厅','ting' 
437  insert into @geovindu select N'乭','tol' 
438  insert into @geovindu select N'囲','tong' 
439  insert into @geovindu select N'偷','tou' 
440  insert into @geovindu select N'凸','tu' 
441  insert into @geovindu select N'湍','tuan' 
442  insert into @geovindu select N'推','tui' 
443  insert into @geovindu select N'旽','tun' 
444  insert into @geovindu select N'乇','tuo' 
445  insert into @geovindu select N'屲','wa' 
446  insert into @geovindu select N'歪','wai' 
447  insert into @geovindu select N'乛','wan' 
448  insert into @geovindu select N'尣','wang' 
449  insert into @geovindu select N'危','wei' 
450  insert into @geovindu select N'塭','wen' 
451  insert into @geovindu select N'翁','weng' 
452  insert into @geovindu select N'挝','wo' 
453  insert into @geovindu select N'乌','wu' 
454  insert into @geovindu select N'夕','xi' 
455  insert into @geovindu select N'诶','ei' 
456  insert into @geovindu select N'疨','xia' 
457  insert into @geovindu select N'仙','xian' 
458  insert into @geovindu select N'乡','xiang' 
459  insert into @geovindu select N'灱','xiao' 
460  insert into @geovindu select N'楔','xie' 
461  insert into @geovindu select N'心','xin' 
462  insert into @geovindu select N'星','xing' 
463  insert into @geovindu select N'凶','xiong' 
464  insert into @geovindu select N'休','xiu' 
465  insert into @geovindu select N'旴','xu' 
466  insert into @geovindu select N'昍','xuan' 
467  insert into @geovindu select N'疶','xue' 
468  insert into @geovindu select N'坃','xun' 
469  insert into @geovindu select N'丫','ya' 
470  insert into @geovindu select N'咽','yan' 
471  insert into @geovindu select N'欕','eom' 
472  insert into @geovindu select N'央','yang' 
473  insert into @geovindu select N'涂','tu'
474  insert into @geovindu select N'聚','ju'
475  insert into @geovindu select N'文','wen'
476  insert into @geovindu select N'吆','yao' 
477  insert into @geovindu select N'椰','ye' 
478  insert into @geovindu select N'膶','yen' 
479  insert into @geovindu select N'一','yi' 
480  insert into @geovindu select N'乁','i' 
481  insert into @geovindu select N'乚','yin' 
482  insert into @geovindu select N'应','ying' 
483  insert into @geovindu select N'哟','yo' 
484  insert into @geovindu select N'佣','yong' 
485  insert into @geovindu select N'优','you' 
486  insert into @geovindu select N'迂','yu' 
487  insert into @geovindu select N'囦','yuan' 
488  insert into @geovindu select N'曰','yue' 
489  insert into @geovindu select N'蒀','yun' 
490  insert into @geovindu select N'帀','za' 
491  insert into @geovindu select N'災','zai' 
492  insert into @geovindu select N'兂','zan' 
493  insert into @geovindu select N'牂','zang' 
494  insert into @geovindu select N'遭','zao' 
495  insert into @geovindu select N'啫','ze' 
496  insert into @geovindu select N'贼','zei' 
497  insert into @geovindu select N'怎','zen' 
498  insert into @geovindu select N'曽','zeng' 
499  insert into @geovindu select N'吒','zha' 
500  insert into @geovindu select N'甴','gad' 
501  insert into @geovindu select N'夈','zhai' 
502  insert into @geovindu select N'毡','zhan' 
503  insert into @geovindu select N'张','zhang' 
504  insert into @geovindu select N'钊','zhao' 
505  insert into @geovindu select N'蜇','zhe' 
506  insert into @geovindu select N'贞','zhen' 
507  insert into @geovindu select N'凧','zheng' 
508  insert into @geovindu select N'之','zhi' 
509  insert into @geovindu select N'中','zhong' 
510  insert into @geovindu select N'州','zhou' 
511  insert into @geovindu select N'劯','zhu' 
512  insert into @geovindu select N'抓','zhua' 
513  insert into @geovindu select N'专','zhuan' 
514  insert into @geovindu select N'转','zhuai' 
515  insert into @geovindu select N'妆','zhuang' 
516  insert into @geovindu select N'骓','zhui' 
517  insert into @geovindu select N'宒','zhun' 
518  insert into @geovindu select N'卓','zhuo' 
519  insert into @geovindu select N'孜','zi' 
520  insert into @geovindu select N'唨','zo' 
521  insert into @geovindu select N'宗','zong' 
522  insert into @geovindu select N'棸','zou' 
523  insert into @geovindu select N'哫','zu' 
524  insert into @geovindu select N'劗','zuan' 
525  insert into @geovindu select N'厜','zui' 
526  insert into @geovindu select N'尊','zun' 
527  insert into @geovindu select N'昨','zuo' 
528  insert into @geovindu select N'孙','sun'
529  insert into @geovindu select N'斯','si'
530 
531  declare @strlen int 
532  select @strlen=len(@str),@re=''
533  while @strlen>0
534  begin     
535       select top 1 @re=UPPER(substring(py,1,1) )+substring(py,2,len(py))+@re,@strlen=@strlen-1 
536       from @geovindu a where chr<=substring(@str,@strlen,1) 
537       order by chr collate Chinese_PRC_CS_AS_KS_WS  desc 
538       if @@rowcount=0
539         select @re=substring(@str,@strlen,1)+@re,@strlen=@strlen-1
540    end
541  return(@re)
542 end
543 GO測試代碼如下：
  --測試在功（其它应用于可想而知了，这里不多说了）
 SELECT dbo.f_GetPy('人昨涂聚文宗斯博') as '拼音'
 GO 
 測試代碼如下：
2 
3 --測試在功（其它应用于可想而知了，这里不多说了）
4 SELECT dbo.f_GetPy('人昨涂聚文涂斯博') as '拼音'
5 GO 

544 GO