FOR
这是一张存放员工的任务表(数据乱填的,表也是随意建的)
FOR
SELECT * FROM TBL_Task_info FOR
查询结果:
而且,它的节点名称是可以改变的,如下:
SELECT Task_ID AS 'ID',Task_Name AS 'Name',Employee_ID AS 'Employee' FROM TBL_Task_info FOR 'Task')
任务一 小一,小二,小三
SQL语句如下:
SELECT B.Task_Name,LEFT(EmployeeList,LEN(EmployeeList)-1) as Employee FROM(SELECT Task_Name,(SELECT Employee_ID+',' FROM TBL_Task_info WHERE Task_Name=A.Task_Name FOR '')) AS EmployeeList FROM TBL_Task_info AS AGROUP BY Task_ID,Task_Name) B
效果:
以后,总有地方会用到的。
原标题:SQL FOR XML PATH 用法
关键词:sql