相应的数据生成 在我的资源里:http://download.csdn.net/source/570706同步更新在我的blog:http://blog.csdn.net/happyflystone/archive/2008/08/04/2768114.aspx------------------------------------
-- Author:Flystone
-- Version:V1.001
-- Date:2008-08-04 21:56:11
-- 转载注明出处
------------------------------------ alter function f_getinfo(@cid varchar(18))
returns varchar(100)
as
begin
--不做合法性检测
declare @s varchar(100)
select @s = isnull(@s ,'') + case when descrp = '县' then '' else descrp end
from sfz_info
where dm = left(@cid,2) +'0000' or dm = left(@cid,4) +'00' or dm = left(@cid,6)
order by dm
return @s
end go
select dbo.f_getinfo('110229************')
/*
----------------------------------------------------------------------------------------------------
北京市延庆县 (所影响的行数为 1 行)
*/ select dbo.f_getinfo('110102************')
/*
----------------------------------------------------------------------------------------------------
北京市市辖区西城区 (所影响的行数为 1 行) */
select dbo.f_getinfo('431229************')
/*
----------------------------------------------------------------------------------------------------
湖南省怀化市靖州苗族侗族自治县 (所影响的行数为 1 行) */
-- Author:Flystone
-- Version:V1.001
-- Date:2008-08-04 21:56:11
-- 转载注明出处
------------------------------------ alter function f_getinfo(@cid varchar(18))
returns varchar(100)
as
begin
--不做合法性检测
declare @s varchar(100)
select @s = isnull(@s ,'') + case when descrp = '县' then '' else descrp end
from sfz_info
where dm = left(@cid,2) +'0000' or dm = left(@cid,4) +'00' or dm = left(@cid,6)
order by dm
return @s
end go
select dbo.f_getinfo('110229************')
/*
----------------------------------------------------------------------------------------------------
北京市延庆县 (所影响的行数为 1 行)
*/ select dbo.f_getinfo('110102************')
/*
----------------------------------------------------------------------------------------------------
北京市市辖区西城区 (所影响的行数为 1 行) */
select dbo.f_getinfo('431229************')
/*
----------------------------------------------------------------------------------------------------
湖南省怀化市靖州苗族侗族自治县 (所影响的行数为 1 行) */
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货