--> 数据库版本: --> Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 --> 测试数据:[TB] IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[TB]') AND type in (N'U')) DROP TABLE [TB] GO---->建表 create table [TB]([字段1] varchar(1),[字段2] varchar(1)) insert [TB] select 'a','c' union all select 'b','c' GO SELECT 字段1 =stuff(( select '+'',''+'+convert(varchar(20),字段1) FROM [TB] WHERE 字段2 = a.字段2 for xml path('')) ,1,5,''),a.字段2 FROM [TB] a group by a.字段2--> 查询结果 SELECT * FROM [TB] --> 删除表格 --DROP TABLE [TB]
--> 数据库版本:
--> Microsoft SQL Server 2008 (RTM) - 10.0.1600.22
--> 测试数据:[TB]
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[TB]')
AND type in (N'U'))
DROP TABLE [TB]
GO---->建表
create table [TB]([字段1] varchar(1),[字段2] varchar(1))
insert [TB]
select 'a','c' union all
select 'b','c'
GO
SELECT
字段1 =stuff((
select '+'',''+'+convert(varchar(20),字段1) FROM [TB] WHERE 字段2 = a.字段2 for xml path(''))
,1,5,''),a.字段2
FROM [TB] a
group by a.字段2--> 查询结果
SELECT * FROM [TB]
--> 删除表格
--DROP TABLE [TB]