DBS-Function:f_GetPy

ylbtech-SQL Server-Function:f_GetPy
 
A, 返回顶部
1、f_GetPy
Create function   [dbo].[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
2、
B,返回顶部
 
C,返回顶部
 
D,返回顶部
 
warn 作者:ylbtech
出处:http://storebook.cnblogs.com/
本文版权归作者和博客园共有,欢迎转载,但未经作者同意必须保留此段声明,且在文章页面明显位置给出原文连接,否则保留追究法律责任的权利。
posted on 2018-06-19 10:53  ylbtech  阅读(449)  评论(0编辑  收藏  举报