CREATE FUNCTION fun_hong_py(@nr VARCHAR(1000)) RETURNS @temp TABLE(pyall VARCHAR(10),wball VARCHAR(10))
AS
/*---根据汉字内容自动产生拼音和五笔首字母--*/
BEGIN
DECLARE @py VARCHAR(1)
DECLARE @wb VARCHAR(1)
DECLARE @i INT
DECLARE @j INT
DECLARE @pyall VARCHAR(10)
DECLARE @wball VARCHAR(10)
SELECT @j=1
SELECT @i=LEN(@nr)
SELECT @pyall=''
SELECT @wball=''
WHILE @i>0
BEGIN
IF EXISTS(SELECT 1 FROM dbo.hzpytmp WHERE bhz=SUBSTRING(@nr,@j,1))
BEGIN
SELECT @py=bsm,@wb=wbm FROM dbo.hzpytmp WHERE bhz=SUBSTRING(@nr,@j,1)
SELECT @i=@i-1
SELECT @j=@j+1
SELECT @pyall=@pyall+@py
SELECT @wball=@wb
sql根据汉字内容自动产生拼音和五笔首字母
最新推荐文章于 2020-06-19 13:44:04 发布