------------------------例---------------------------------------
create table table1 (a int,b varchar(50),c int)
goinsert table1 values(1,'aaa',1)
insert table1 values(1,'bbb',1)
insert table1 values(2,'ccc',2)
insert table1 values(2,'dd',2)
gocreate function getstr(@content int,@a int)
returns varchar(2000)
as
begin
declare @str varchar(2000)
set @str=''
select @str=@str+','+rtrim(b) from table1
where a=@content and c=@a
set @str=right(@str,len(@str)-1)
return @str
end
go
select a,c,dbo.getstr(a,c) from table1 group by a,c
create table table1 (a int,b varchar(50),c int)
goinsert table1 values(1,'aaa',1)
insert table1 values(1,'bbb',1)
insert table1 values(2,'ccc',2)
insert table1 values(2,'dd',2)
gocreate function getstr(@content int,@a int)
returns varchar(2000)
as
begin
declare @str varchar(2000)
set @str=''
select @str=@str+','+rtrim(b) from table1
where a=@content and c=@a
set @str=right(@str,len(@str)-1)
return @str
end
go
select a,c,dbo.getstr(a,c) from table1 group by a,c
字段值: 1 a
1 b
1 c通过SQL语句,使它返回 1,a,b,c
select * from #temp where ID_Num>10 and ID_Num<=20
select * from #temp where ID_Num>10 and ID_Num<=20
goinsert table1 values(1,'aaa')
insert table1 values(1,'bbb')
insert table1 values(2,'ccc')
insert table1 values(2,'dd')
gocreate function getstr(@content int)
returns varchar(2000)
as
begin
declare @str varchar(2000)
set @str=''
select @str=@str+','+rtrim(b) from table1
where a=@content
set @str=right(@str,len(@str)-1)
return @str
end
go
select a+','+dbo.getstr(a) from table1 group by a
goinsert table1 values(1,'aaa')
insert table1 values(1,'bbb')
insert table1 values(2,'ccc')
insert table1 values(2,'dd')
gocreate function getstr(@content int)
returns varchar(2000)
as
begin
declare @str varchar(2000)
set @str=''
select @str=@str+','+rtrim(b) from table1
where a=@content
set @str=right(@str,len(@str)-1)
return @str
end
go
select cast(a as varchar)+','+dbo.getstr(a) from table1 group by a