sqlserver实现取相同名称放在同一字段
if object_id('[tbtest]') is not null drop table [tbtest]
create table tbtest
(
A varchar(10) not null,
B varchar(50) not null
)
go
insert into tbtest
select 'A',1 union all
select'A',2 union all
select'A',3 union all
select'B',4 union all
select'B',5 union all
select'B',6 union all
select'B',7 union all
select'C',8 union all
select'C',9 union all
select'C',10 union all
select'C',11
go
if object_id('[dbo].[functiontest]') is not null drop function [dbo].[functiontest]
go
create function functiontest()
returns @tb table(A varchar(10),B varchar(50))
AS
begin
declare @a varchar(50)
declare @b varchar(50)
declare temp_cur cursor local for
select * from tbtest
open temp_cur
fetch next from temp_cur into @a,@b
while (@@fetch_status = 0)
begin
if(not exists(select * from @tb where A = @a))
insert into @tb(A,B)values(@a,@b)
else
update @tb set B = B + ',' + @b where A = @a
fetch next from temp_cur into @a,@b
end
return
end
go
select * from functiontest()
go
