sqlserver根據拼音查詢資料,sqlserver拼音查詢

來源:互聯網
上載者:User

sqlserver根據拼音查詢資料,sqlserver拼音查詢

直接將底下的函數執行,通過後台傳入相應的參數即可查詢資料

create function   f_GetPy(@str   nvarchar(4000)) returns   nvarchar(4000) as begin declare   @strlen   int,@re   nvarchar(4000) declare   @t   table(chr   nchar(1)   collate   Chinese_PRC_CI_AS,letter   nchar(1)) insert   into   @t(chr,letter)     select   '吖 ', 'A '   union   all   select   '八 ', 'B '   union   all     select   '嚓 ', 'C '   union   all   select   '咑 ', 'D '   union   all     select   '妸 ', 'E '   union   all   select   '發 ', 'F '   union   all     select   '旮 ', 'G '   union   all   select   '鉿 ', 'H '   union   all     select   '丌 ', 'J '   union   all   select   '哢 ', 'K '   union   all     select   '垃 ', 'L '   union   all   select   '嘸 ', 'M '   union   all     select   '拏 ', 'N '   union   all   select   '噢 ', 'O '   union   all     select   '妑 ', 'P '   union   all   select   '七 ', 'Q '   union   all     select   '呥 ', 'R '   union   all   select   '仨 ', 'S '   union   all     select   '他 ', 'T '   union   all   select   '屲 ', 'W '   union   all     select   '夕 ', 'X '   union   all   select   '丫 ', 'Y '   union   all     select   '帀 ', 'Z '     select   @strlen=len(@str),@re= ' '     while   @strlen> 0     begin         select   top   1   @re=letter+@re,@strlen=@strlen-1             from   @t   a   where   chr <=substring(@str,@strlen,1)             order   by   chr   desc         if   @@rowcount=0             select   @re=substring(@str,@strlen,1)+@re,@strlen=@strlen-1     end     return(@re) end   ---查詢---select   * from   [pactinfo]where  left(dbo.f_GetPy(pactname),1)='Z' 


相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.