|
生成助记码（取汉字的第一个字母）(1)
SET NOCOUNT ON
GO
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' )
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' )
INSERT [hzpy] ( [Hz] , [Py] ) VALUES ( '暧' , 'A' )
INSERT [hzpy] ( [Hz] , [Py] ) VALUES ( '瑷' , 'A' )
INSERT [hzpy] ( [Hz] , [Py] ) VALUES ( '安' , 'A' )
|
