create function getstr(@a int)
returns varchar(2000)
as
begin
declare @str varchar(2000)
set @str=''
select @str=@str+','+rtrim(b) from a where a=@a
set @str=right(@str,len(@str)-1)
return @str
end
go--语句:
select a,dbo.getstr(a) from a group by a
returns varchar(2000)
as
begin
declare @str varchar(2000)
set @str=''
select @str=@str+','+rtrim(b) from a where a=@a
set @str=right(@str,len(@str)-1)
return @str
end
go--语句:
select a,dbo.getstr(a) from a group by a
解决方案 »
- SQL Server 不能自动更新补丁?
- sql2005 无法连接
- 求救`~~ 游标怎么实现 求求求~~~~~~~~
- 如何利用一条SQL语句统计一个学生成绩库不同分数段的人数
- 一个复杂的SQL排序问题?高手请进!!!!!!!!!
- 4个月来学SQl Sever的一些过程
- VB6.0与远程的SQL SERVER连接,请问有什么好书吗?我很急,我马上要做一个课程设计!谢谢大家!
- 把dbf数据库通过DTS导入成SQL2000数据库,汉字成了乱码,如何办?
- 再问:为什么我在使用SQLDMO进行异地备份数据库时,总提示出错(我使用的)。在线等待,急!
- 关于批量插入修改删除的方案
- SQL语句中单引号和双引号有什么区别?
- 菜鸟请教三个简单问题,(四舍五入,小数显示成百分比...)
delcare @a int,@b varchar(8000)
update #t set @b=case @a when a then @b+','+b else b end
,aa=@b,@a=a
select a,b=max(aa) from #t group by a
dorp table #t
我怎么不行呀!!!急Drop Table #t
Declare @t table (
a int,
b char(4)
)Insert into @t Values(1,'a')
Insert into @t Values(2,'b')
Insert into @t Values(2,'c')
Insert into @t Values(3,'d')
Insert into @t Values(3,'e')
Insert into @t Values(3,'f')select *,aa=cast('' as varchar(8000)) into #t from @t order by adeclare @a int,@b varchar(8000)update #t
set @b=
case @a
when a
then @b+','+b
else b
end
,aa=@b,@a=aselect a,b=max(aa) from #t group by a
Drop Table #tDeclare @t table (a int,b char(4))Insert into @t Values(1,'a')
Insert into @t Values(2,'b')
Insert into @t Values(2,'c')
Insert into @t Values(3,'d')
Insert into @t Values(3,'e')
Insert into @t Values(3,'f')select *,aa=cast('' as varchar(8000)) into #t from @t order by adeclare @a int,@b varchar(8000)
update #t
set @b=case @a when a then @b+','+rtrim(b) else rtrim(b) end
,aa=@b,@a=aselect a,b=max(aa) from #t group by a
FROM a as t1 INNER JOIN
a b t2 t1.a = t2.a