【SQL 编程你也行】SQL Server中实现数据换行

最新推荐文章于 2024-08-11 03:22:49 发布

weixin_30481087

最新推荐文章于 2024-08-11 03:22:49 发布

阅读量1k

点赞数

原文链接：http://www.cnblogs.com/momogua/p/8304417.html

版权

本文介绍了在SQL Server中如何实现数据换行的两种方法：一种是在拼接数据时使用回车符(char(10))，另一种是在网页显示时利用replace函数将'<br>'标签替换为换行。

摘要由CSDN通过智能技术生成

在sql server 里，可以这么合并数据：

with  t
as
(

select 1 as id,'产品1' p,'类型1' as v union all
select 2 as id,'产品2','类型1' as v union all
select 3 as id,'产品3','类型1' as v union all
select 4 as id,'产品1','类型2' as v union all
select 5 as id,'产品4','类型2' as v union all
select 6 as id,'产品5','类型3' as v union all
select 7 as id,'产品6','类型3' as v union all
select 8 as id,'产品7','类型3' as v union all
select 9 as id,'产品8','类型3' as v union all
select 10 as id,'产品9','类型4' as v 
)

select  v,
        stuff(cast((select ','+tt.p from t tt where t.v = tt.v for xml path('')) as varchar(100)),1,1,'') as p
from t
group by v
/*
v	p
类型1	产品1,产品2,产品3
类型2	产品1,产品4
类型3	产品5,产品6,产品7,产品8