LUKIYA'S NEVERLAND

SQL Server中用逗号连接选择列值的方法。

03/03/2009 12:03:57 AM Views: 44 Pictures: 0

例如Select出的表结构如下

2006 Sping
2006 Fall
2007 Spring
2007 Fall
2008 Spring
2008 Fall

想显示为 2006 Sping,2006 Fall,2007 Spring,2007 Fall,2008 Spring,2008 Fall 的格式

语句很简单，如下:

DECLARE @Seasons NVARCHAR(1000) SELECT @Seasons = ISNULL(@Seasons + ',','')+ '['+LTRIM(SeasonName)+']' FROM (SELECT DISTINCT SeasonName FROM BP_Seasons) AS Temp1

LUKIYA'S NEVERLAND

春去秋来，花谢花开。