生成某字段的拼音码---1、创建中间表（或导入数据）CREATETABLE[tabpy]([id][int]IDENTITY(1,1)NOTNULL,[b_begin][varbinary](2)NULL,[b_end][varbinary](2)NULL,[word][varchar](2)COLLATEChinese_PRC_CI_ASNULL)ON[PRIMARY]GO--复制下面的文字到文本文件中，然后导入到tabpy表中"id","b_begin","b_end","word"1,B0A1,B0C4,"A"2,B0C5,B2C0,"B"3,B2C1,B4ED,"C"4,B4EE,B6E9,"D"5,B6EA,B7A1,"E"6,B7A2,B8C0,"F"7,B8C1,B9FD,"G"8,B9FE,BBF6,"H"9,BBF7,BFA5,"J"10,BFA6,C0AB,"K"11,C0AC,C2E7,"L"12,C2E8,C4C2,"M"13,C4C3,C5B5,"N"14,C5B6,C5BD,"O"15,C5BE,C6D9,"P"16,C6DA,C8BA,"Q"17,C8BB,C8F5,"R"18,C8F6,CBF9,"S"19,CBFA,CDD9,"T"20,CDDA,CEF3,"W"21,CEF4,D1B8,"X"22,D1B9,D4D0,"Y"23,D4D1,D7F9,"Z"----2、创建取拼音首字母的函数：CREATEfunctiongetfirstpy(@avarchar(200))returnsvarchar(100)asbegindeclare@iint,@jint,@resultvarchar(100),@pymvarchar(1)set@result=''set@i=len(@a)set@j=1while@j<=@ibeginselect@result=@result+wordfromtabpywherecast(substring(@a,@j,1)asvarbinary(2))betweenb_beginandb_endorupper(substring(@a,@j,1))=wordset@j=@j+1endreturn@resultend---3、函数的调用updatemxzzyset拼音码=lower(hisv11.dbo.getfirstpy(收费项目))updatemxzzyset拼音码=自定义码where拼音码=''