将数据库中用户表 名称设置对应的拼音账号sql

有这样的一个需求： 需要把用户表里面Users根据名称 设置对应的拼音账号然后替换掉原来的。

步骤1：进入数据库中建立中转的表

create table User1(
	Id uniqueidentifier ,
	Name nvarchar(200), 
	Account nvarchar(200)
)

步骤2.：建立所需要的转换的函数，在对应的数据库中进行建立才能生效

    --调用方法 select dbo. procGetPinYin ('中國')
    create function [dbo].procGetPinYin(@str varchar(100))
    returns varchar(8000)
    as
    begin
     declare @re varchar(8000),@crs varchar(10)
     declare @strlen int 
     select @strlen=len(@str),@re=''
     while @strlen>0
     begin  
      set @crs= substring(@str,@strlen,1)
          select @re=
            case
            when @crs<'吖' then @crs
            when @crs<='厑' then 'a'
            when @crs<='靉' then 'ai'
            when @crs<='黯' then 'an'
            when @crs<='醠' then 'ang'
            when @crs<='驁' then 'ao'
            when @crs<='欛' then 'ba'
            when @crs<='瓸' then 'bai'
            when @crs<='瓣' then 'ban'
            when @crs<='鎊' then 'bang'
            when @crs<='鑤' then 'bao'
            when @crs<='鐾' then 'bei'
            when @crs<='輽' then 'ben'
            when @crs<='鏰' then 'beng'
            when @crs<='鼊' then 'bi'
            when @crs<='變' then 'bian'
            when @crs<='鰾' then 'biao'
            when @crs<='彆' then 'bie'
            when @crs<='鬢' then 'bin'
            when @crs<='靐' then 'bing'
            when @crs<='蔔' then 'bo'
            when @crs<='簿' then 'bu'
            when @crs<='囃' then 'ca'
            when @crs<='乲' then 'cai'
            when @crs<='爘' then 'can'
            when @crs<='賶' then 'cang'
            when @crs<='鼜' then 'cao'
            when @crs<='簎' then 'ce'
            when @crs<='笒' then 'cen'
            when @crs<='乽' then 'ceng'
            when @crs<='詫' then 'cha'
            when @crs<='囆' then 'chai'
            when @crs<='顫' then 'chan'
            when @crs<='韔' then 'chang'
            when @crs<='觘' then 'chao'
            when @crs<='爡' then 'che'
            when @crs<='讖' then 'chen'
            when @crs<='秤' then 'cheng'
            when @crs<='鷘' then 'chi'
            when @crs<='銃' then 'chong'
            when @crs<='殠' then 'chou'
            when @crs<='矗' then 'chu'
            when @crs<='踹' then 'chuai'
            when @crs<='鶨' then 'chuan'
            when @crs<='愴' then 'chuang'
            when @crs<='顀' then 'chui'
            when @crs<='蠢' then 'chun'
            when @crs<='縒' then 'chuo'
            when @crs<='嗭' then 'ci'
            when @crs<='謥' then 'cong'
            when @crs<='輳' then 'cou'
            when @crs<='顣' then 'cu'
            when @crs<='爨' then 'cuan'
            when @crs<='臎' then 'cui'
            when @crs<='籿' then 'cun'
            when @crs<='錯' then 'cuo'
            when @crs<='橽' then 'da'
            when @crs<='靆' then 'dai'
            when @crs<='饏' then 'dan'
            when @crs<='闣' then 'dang'
            when @crs<='纛' then 'dao'
            when @crs<='的' then 'de'
            when @crs<='扽' then 'den'
            when @crs<='鐙' then 'deng'
            when @crs<='螮' then 'di'
            when @crs<='嗲' then 'dia'
            when @crs<='驔' then 'dian'
            when @crs<='鑃' then 'diao'
            when @crs<='嚸' then 'die'
            when @crs<='顁' then 'ding'
            when @crs<='銩' then 'diu'
            when @crs<='霘' then 'dong'
            when @crs<='鬭' then 'dou'
            when @crs<='蠹' then 'du'
            when @crs<='叾' then 'duan'
            when @crs<='譵' then 'dui'
            when @crs<='踲&#