日本综合一区二区|亚洲中文天堂综合|日韩欧美自拍一区|男女精品天堂一区|欧美自拍第6页亚洲成人精品一区|亚洲黄色天堂一区二区成人|超碰91偷拍第一页|日韩av夜夜嗨中文字幕|久久蜜综合视频官网|精美人妻一区二区三区

使用sql函數(shù)，如何生成助記碼呢？下面就將為您介紹sql函數(shù)生成助記碼的方法實例，供您參考，希望對您學(xué)習(xí)sql函數(shù)的使用能有所啟示。

--助記碼匹配庫
IF EXISTS(SELECT name
   FROM   sysobjects
   WHERE name = N'hzpy'
   AND   type = 'U')
    DROP TABLE hzpy
GO
CREATE TABLE [hzpy] ( [Hz] [char] (2) NOT NULL , [Py] [char] (1) NULL )
CREATE CLUSTERED INDEX [IX_hzpy] ON [hzpy] ( Hz )
INSERT [hzpy] ( [Hz] , [Py] ) VALUES ( '吖' , 'A' )
INSERT [hzpy] ( [Hz] , [Py] ) VALUES ( '阿' , 'A' )
INSERT [hzpy] ( [Hz] , [Py] ) VALUES ( '啊' , 'A' )
INSERT [hzpy] ( [Hz] , [Py] ) VALUES ( '錒' , 'A' )
INSERT [hzpy] ( [Hz] , [Py] ) VALUES ( '嗄' , 'S' )
INSERT [hzpy] ( [Hz] , [Py] ) VALUES ( '哎' , 'A' )
INSERT [hzpy] ( [Hz] , [Py] ) VALUES ( '哀' , 'A' )
INSERT [hzpy] ( [Hz] , [Py] ) VALUES ( '唉' , 'A' )
INSERT [hzpy] ( [Hz] , [Py] ) VALUES ( '埃' , 'A' )
INSERT [hzpy] ( [Hz] , [Py] ) VALUES ( '挨' , 'A' )
INSERT [hzpy] ( [Hz] , [Py] ) VALUES ( '锿' , 'A' )
INSERT [hzpy] ( [Hz] , [Py] ) VALUES ( '捱' , 'A' )
INSERT [hzpy] ( [Hz] , [Py] ) VALUES ( '皚' , 'A' )
INSERT [hzpy] ( [Hz] , [Py] ) VALUES ( '癌' , 'A' )
INSERT [hzpy] ( [Hz] , [Py] ) VALUES ( '噯' , 'A' )

--定義dbo.getpy函數(shù)
IF EXISTS (SELECT *
    FROM   sysobjects
    WHERE name = N'getpy')
DROP FUNCTION getpy
GO

CREATE FUNCTION getpy(@hz varchar(30))
RETURNS varchar(30)
AS
BEGIN
declare @py varchar(30)
declare @num int
declare @i int
set @py=''
set @num=len(@hz)
set @i=1
while @i<=@num
begin
select @py=@py+py from hzpy where hz = substring(@hz,@i,1)
if @@rowcount=0
   select @py=@py+substring(@hz,@i,1)
select @i=@i+1
end
return @py
END
GO

--例子
select dbo.getpy('愛老虎油')
select dbo.getpy(shengccj),shengccj,* from docdsp

網(wǎng)頁題目：sql函數(shù)生成助記碼的實例
文章分享：http://www.dlmjj.cn/article/djesgic.html