连接行值 [英] Concatenating Row Values

问题描述

我使用的是 Microsoft SQL Server 2005 并且能够根据以下查询连接行值:

I was using Microsoft SQL server 2005 and was able to concatenate row values based on the following query:

SELECT e1.EMP_ID,
( SELECT cast(Sector_ID as varchar(10)) + ';'
FROM Employee_Sector_relationship e2
WHERE e2.Emp_ID = e1.Emp_ID
ORDER BY Sector_ID
FOR XML PATH('') ) AS Sectors
FROM Employee_Sector_Relationship e1
GROUP BY Emp_ID

但它在 Microsoft Server 2000 中不起作用.它在 for 关键字附近给我一个错误.谁能帮我连接 Microsoft Server 2000 中的行值?

But it doesn't work in Microsoft Server 2000. It gives me an error near the for keyword. Can anyone help me to concatenate the row values in Microsoft Server 2000?

推荐答案

这是一种应该适合您的技术.如果您愿意，您可以在一个批处理语句中执行此操作:

This is a technique that should work for you. You can execute this in one batch statement if you wish:

DECLARE @EmployeeList varchar(100)

SELECT @EmployeeList = COALESCE(@EmployeeList + ', ', '') + 
   CAST(Emp_UniqueID AS varchar(5))
FROM SalesCallsEmployees
WHERE SalCal_UniqueID = 1

SELECT @EmployeeList

有关详细信息，请参阅使用 COALESCE 构建逗号分隔的字符串.

For more information, see Using COALESCE to Build Comma-Delimited String.

这篇关于连接行值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！