--比较发音相同的全字符串
create function f_getsound_all(@code varchar(50))
returns varchar(4)
as
begin
declare @v varchar(4),@i int,@j int
set @v=''
set @i=0
set @j=len(ltrim(@code))
while @i<@j
begin
set @i=@i+1
set @v=@v+substring(master.dbo.fn_varbintohexstr(cast(substring(@code,@i,1) as varbinary(10))),3,3)
end
return @v
end declare @a table (code varchar(10))
insert into @a values('王一')
insert into @a values('汪一')
insert into @a values('刘三')
insert into @a values('章四')
insert into @a values('张五')
insert into @a values('网六')select * from @a where dbo.f_getsound_all(code)=dbo.f_getsound_all('汪一')
查询结果:
王一
汪一
create function f_getsound_all(@code varchar(50))
returns varchar(4)
as
begin
declare @v varchar(4),@i int,@j int
set @v=''
set @i=0
set @j=len(ltrim(@code))
while @i<@j
begin
set @i=@i+1
set @v=@v+substring(master.dbo.fn_varbintohexstr(cast(substring(@code,@i,1) as varbinary(10))),3,3)
end
return @v
end declare @a table (code varchar(10))
insert into @a values('王一')
insert into @a values('汪一')
insert into @a values('刘三')
insert into @a values('章四')
insert into @a values('张五')
insert into @a values('网六')select * from @a where dbo.f_getsound_all(code)=dbo.f_getsound_all('汪一')
查询结果:
王一
汪一
怎莫进行反编译?
*.mb
[Text]
啊a
....将这个文档导入数据中处理,即可得到对照表,在你的机器上搜索一下*.MD,看有没有pingying.MD.
可支持大字符集20000个汉字!create function f_ch2py(@chn nchar(1))
returns char(1)
as
begin
declare @n int
declare @c char(1)
set @n = 63select @n = @n +1,
@c = case chn when @chn then char(@n) else @c end
from(
select top 27 * from (
select chn =
'吖' union all select
'八' union all select
'嚓' union all select
'咑' union all select
'妸' union all select
'发' union all select
'旮' union all select
'铪' union all select
'丌' union all select --because have no 'i'
'丌' union all select
'咔' union all select
'垃' union all select
'嘸' union all select
'拏' union all select
'噢' union all select
'妑' union all select
'七' union all select
'呥' union all select
'仨' union all select
'他' union all select
'屲' union all select --no 'u'
'屲' union all select --no 'v'
'屲' union all select
'夕' union all select
'丫' union all select
'帀' union all select @chn) as a
order by chn COLLATE Chinese_PRC_CI_AS
) as b
return(@c)
end
goselect dbo.f_ch2py('中') --Z
select dbo.f_ch2py('国') --G
select dbo.f_ch2py('人') --R
select dbo.f_ch2py('镆') --M
-----------------调用
CREATE FUNCTION F_GetHelpCode (
@cName VARCHAR(20) )
RETURNS VARCHAR(12)
AS
BEGIN
DECLARE @i SMALLINT, @L SMALLINT , @cHelpCode VARCHAR(12), @e VARCHAR(12), @iAscii SMALLINT
SELECT @i=1, @L=0 , @cHelpCode=''
while @L<=12 AND @i<=LEN(@cName) BEGIN
SELECT @e=LOWER(SUBSTRING(@cname,@i,1))
SELECT @iAscii=ASCII(@e)
IF @iAscii>=48 AND @iAscii <=57 OR @iAscii>=97 AND @iAscii <=122 or @iAscii=95
SELECT @cHelpCode=@cHelpCode +@e
ELSE
IF @iAscii>=176 AND @iAscii <=247
SELECT @cHelpCode=@cHelpCode + dbo.f_ch2py(@e)
ELSE SELECT @L=@L-1
SELECT @i=@i+1, @L=@L+1 END
RETURN @cHelpCode
END
GO--调用
select dbo.F_GetHelpCode('大力')
如果看过就对不起了,其实后面的过程你也可以套用一下
可支持大字符集20000个汉字!create function f_ch2py(@chn nchar(1))
returns char(1)
as
begin
declare @n int
declare @c char(1)
set @n = 63select @n = @n +1,
@c = case chn when @chn then char(@n) else @c end
from(
select top 27 * from (
select chn =
'吖' union all select
'八' union all select
'嚓' union all select
'咑' union all select
'妸' union all select
'发' union all select
'旮' union all select
'铪' union all select
'丌' union all select --because have no 'i'
'丌' union all select
'咔' union all select
'垃' union all select
'嘸' union all select
'拏' union all select
'噢' union all select
'妑' union all select
'七' union all select
'呥' union all select
'仨' union all select
'他' union all select
'屲' union all select --no 'u'
'屲' union all select --no 'v'
'屲' union all select
'夕' union all select
'丫' union all select
'帀' union all select @chn) as a
order by chn COLLATE Chinese_PRC_CI_AS
) as b
return(@c)
end
goselect dbo.f_ch2py('中') --Z
select dbo.f_ch2py('国') --G
select dbo.f_ch2py('人') --R
select dbo.f_ch2py('镆') --M
-----------------调用
CREATE FUNCTION F_GetHelpCode (
@cName VARCHAR(20) )
RETURNS VARCHAR(12)
AS
BEGIN
DECLARE @i SMALLINT, @L SMALLINT , @cHelpCode VARCHAR(12), @e VARCHAR(12), @iAscii SMALLINT
SELECT @i=1, @L=0 , @cHelpCode=''
while @L<=12 AND @i<=LEN(@cName) BEGIN
SELECT @e=LOWER(SUBSTRING(@cname,@i,1))
SELECT @iAscii=ASCII(@e)
IF @iAscii>=48 AND @iAscii <=57 OR @iAscii>=97 AND @iAscii <=122 or @iAscii=95
SELECT @cHelpCode=@cHelpCode +@e
ELSE
IF @iAscii>=176 AND @iAscii <=247
SELECT @cHelpCode=@cHelpCode + dbo.f_ch2py(@e)
ELSE SELECT @L=@L-1
SELECT @i=@i+1, @L=@L+1 END
RETURN @cHelpCode
END
GO--调用
select dbo.F_GetHelpCode('大力')
如果看过就对不起了,其实后面的过程你也可以套用一下