求一小段 sql语句的注释
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

非常感谢
http://zhidao.baidu.com/question/646979833337800605.html?quesup2&oldq=1
我在百度也问了同样的问题，欢迎两面拿分
[解决办法]
对每个字符遍历，判断数据是否在函数那堆数据里面，是的话转换成对应的字符
[解决办法]

create function   f_GetPy(@str   nvarchar(4000)) 
returns   nvarchar(4000) 
as 
begin 
declare   @strlen   int,@re   nvarchar(4000) 

--就是定义了一个表变量 @t 

-- 然后把文字和对应的拼音首字母插入到@t中
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= ' ' 
    
    --长度大于0
    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 
        
        --取出下一个字符，字符长度减去1   
        if   @@rowcount=0 
            select   @re=substring(@str,@strlen,1)+@re,@strlen=@strlen-1 
    end 
    return(@re) 
end 

[解决办法]
这不是个取助记码的标量值函数么？

http://blog.csdn.net/yole_grise/article/details/14122895