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' )
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' )
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 ( '八' , 'b' )
insert [hzpy] ( [hz] , [py] ) values ( '巴' , 'b' )
insert [hzpy] ( [hz] , [py] ) values ( '叭' , 'b' )
insert [hzpy] ( [hz] , [py] ) values ( '扒' , 'b' )
insert [hzpy] ( [hz] , [py] ) values ( '吧' , 'b' )
insert [hzpy] ( [hz] , [py] ) values ( '岜' , 'b' )
