一个sqlserver中用到的函数，用来取拼音

<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

createfunctionf_GetPy(@strnvarchar(4000))
returnsnvarchar(4000)
as
begin
declare@strlenint,@renvarchar(4000)
declare@ttable(chrnchar(1)collateChinese_PRC_CI_AS,letternchar(1))
insertinto@t(chr,letter)
 select'吖','A'unionallselect'八','B'unionall
 select'嚓','C'unionallselect'咑','D'unionall
 select'妸','E'unionallselect'发','F'unionall
 select'旮','G'unionallselect'铪','H'unionall
 select'丌','J'unionallselect'咔','K'unionall
 select'垃','L'unionallselect'呒','M'unionall
 select'拏','N'unionallselect'噢','O'unionall
 select'妑','P'unionallselect'七','Q'unionall
 select'呥','R'unionallselect'仨','S'unionall
 select'他','T'unionallselect'屲','W'unionall
 select'夕','X'unionallselect'丫','Y'unionall
 select'帀','Z'
 select@strlen=len(@str),@re=''
 while@strlen>0
 begin
   selecttop1@re=letter+@re,@strlen=@strlen-1
     from@tawherechr<=substring(@str,@strlen,1)
     orderbychrdesc
   if@@rowcount=0
     select@re=substring(@str,@strlen,1)+@re,@strlen=@strlen-1
 end
 return(@re)
end
go
--调用
select*fromallswheredbo.f_GetPy(name)='cyml'
<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>