检索SQL关系作为逗号分隔的字符串

问题描述：

我有一个SQL Server 2005数据库有两个表：Order，LineItem。每个LineItem都有一个名为LineItemID和OrderID的字段。我有一个查询，获取所有的数据库中的订单记录。对于每个订单记录，我想检索与订单相关联的LineItemID的逗号分隔列表。

I have a SQL Server 2005 database with two tables: Order, LineItem. Each LineItem has a field called LineItemID and OrderID. I have a query that is getting all of the Order records in my database. With each Order record, I would like to retrieve a comma delimited list of LineItemIDs associated with the Order.

在SQL中有办法做到这一点吗？

Is there a way to do this in SQL? I do not know how to do this.

谢谢！

答

p>这里有一个例子，使用sys.tables中的name列，如何从列中构造以逗号分隔的字符串：

Here's one example, using the name column from sys.tables, of how to construct a comma-delimited string from a column:

use master
go

SELECT Stuff((SELECT ',' + name
              FROM sys.tables
              For XML PATH ('')),1,1,'')
go

检索SQL关系作为逗号分隔的字符串

相关推荐