27,580
社区成员
发帖
与我相关
我的任务
分享
insert py select left(tt,1),substring(tt+' ',2,charindex(' ',tt+' ')-1) from tt_text
where patindex('%[a-zA-Z]%',TT) = 2
create table py(hz varchar(10),py varchar(20))
create table tt_text(tt varchar(1000))
BULK INSERT tt_text from 'e:\py.txt'
insert py select left(tt,1),substring(tt+' ',2,charindex(' ',tt+' ')-1) from tt_text
select * from py
/*
hz py
---------- --------------------
肯 ken
啃 ken
恳 ken
垦 ken
裉 ken
垠 ken
墾 ken
懇 ken
掯 ken
狠 ken
珢 ken
硍 ken
肎 ken
肻 ken
褃 ken
豤 ken
貇 ken
錹 ken
頎 ken
颀 ken
齦 ken
龈 ken
*/
create table py(hz varchar(10),py varchar(20))
create table tt_text(tt varchar(1000))
BULK INSERT tt_text from 'e:\py.txt'
insert py select left(tt,1),substring(tt+' ',2,charindex(' ',tt+' ')-1) from tt_text
insert py select left(tt,1),substring(tt+' ',2,charindex(' ',tt+' ')-1) from tt_text
where patindex('%[a-zA-Z]%',TT) = 2
insert py select left(tt,1),substring(tt+' ',2,charindex(' ',tt+' ')-1) from tt_text
where patindex('%[a-zA-Z]%',TT) = 2
--再建一函数:汉字转拼音
create function dbo.getpy(@c varchar(20))
returns varchar(1000)
as
begin
declare @py varchar(1000),@i int
select @py = '',@i = 1
while @i<=len(@c)
begin
select @py = @py+'-'+py from py where hz = substring(@c,@i,1)
set @i = @i +1
end
return @py
end
--再建一函数:汉字转拼音
CREATE function dbo.getpy(@c varchar(20))
returns varchar(1000)
as
begin
declare @py varchar(1000),@i int
select @py = '',@i = 1
while @i<=len(@c)
begin
select @py = py from py where hz = substring(@c,@i,1)
set @i = @i +1
end
return @py
end