在程序设计中，为方便用户输入，需设计成用户输入拼音首字母或笔画，电脑显示相应的汉字，下面存储过程演示这一过程； 1、在数据库中建一对应表chinese_tab，内含6W多条汉字对应记录，字段分别为chinese,pingyin,bihua, 表单内容略 2、输入汉字字符串，输出对应的拼音和笔画 CREATEPROCEDURE[dbo].[Pro_CnToBihuaPingYin]@sourceStrvarchar(500),@PinYingStrvarchar(50)out,@BiHuaStrvarchar(50)outASdeclare@othervarchar(150)set@other='qwertyuiopasdfghjklzxcvbnmQWERTYUIOPASDFGHJKLZXCVBNM0123456789!@#$%^&*()_+-=`~,./;[]/<>?:"{}|'declare@iintset@i=0while@i<=len(@sourceStr)beginifcharindex(substring(@sourceStr,@i,1),@other)>0set@sourceStr=replace(@sourceStr,substring(@sourceStr,@i,1),'')set@i=@i+1endset@sourceStr=replace(@sourceStr,'','')declare@chinesevarchar(2)declare@pingyinvarchar(1)declare@bihuavarchar(1)set@PinYingStr=''set@BiHuaStr=''declaretempWpcursorforselectchinese,pingyin,bihuafromdbo.chinese_tabwherecharindex(chinese,@sourceStr)>0opentempWpfetchnextfromtempWpinto@chinese,@pingyin,@bihuawhile@@FETCH_STATUS=0beginif@PinYingStr=''set@PinYingStr=@sourceStrif@BiHuaStr=''set@BiHuaStr=@sourceStrset@PinYingStr=replace(@PinYingStr,@chinese,@pingyin)set@BiHuaStr=replace(@BiHuaStr,@chinese,@bihua)fetchnextfromtempWpinto@chinese,@pingyin,@bihuaendclosetempWpdeallocatetempWpGO
