3707850101
开发区东门家灵芝
37078501
3707850102 开发区东李家灵芝 37078501
3707850103 开发区东王家灵芝 37078501
returns varchar(1000)
as
begin
declare @s varchar(1000)
set @s= ' '
select @s+= ''''+Code+''''+',' from dbo.Administration where ParentCode =@kid
return left(@s,len(@s)-1)
end
--------- 执行一下sql获取相关组合的字符串
select name,dbo.join_value(ParentCode) as str from Administration where ParentCode='37078501'
3707850102 开发区东李家灵芝 37078501
3707850103 开发区东王家灵芝 37078501
----创建一下函数
alter function join_value(@kid varchar(20))returns varchar(1000)
as
begin
declare @s varchar(1000)
set @s= ' '
select @s+= ''''+Code+''''+',' from dbo.Administration where ParentCode =@kid
return left(@s,len(@s)-1)
end
--------- 执行一下sql获取相关组合的字符串
select name,dbo.join_value(ParentCode) as str from Administration where ParentCode='37078501'