摘要:
其实它就是将查询结果集以XML形式展现,有了它我们可以简化我们的查询语句实现一些以前可能需要借助函数活存储过程来完成的工作SELECT SheetID,LEFT(NameLst,LEN(NameLst)-1) AS Names FROM ( SELECT SheetID,( SELECT EmployeeName+',' FROM T_WO_RepairSheetEquipMaintainer (NOLOCK) INNER JOIN T_BD_SupplierMaintanceInfo ON T_WO_RepairSheetEquipMaintainer.MaintainerI 阅读全文
摘要:
Create TABLE tab (CurNum VARCHAR(10),PreNum VARCHAR(10))INSERT INTO tabSELECT '1', Null UNION ALL SELECT '2', '1' UNION ALL SELECT '3', '2' UNION ALL SELECT '4', '1' UNION ALL SELECT '5', Nullselect * from tabSELECT CurNum,PreNum,path=C 阅读全文