RcBuilder@walla.com
call centre: 054-5614020

SQL FOR XML EXPLICIT

Posted by: RcBuilder  /   Category: DBA / FOR XML / SQL / XML   /   No Comments
09
Nov
2014

SQL FOR XML EXPLICIT SELECT 1 AS 'Tag' ,NULL AS 'Parent' ,NULL AS 'XML!1' ,NULL AS 'Company!2!Code' ,NULL AS 'Company!2!Name' ,NULL AS 'Department!3!Code' ,NULL AS 'Department!3!Name' UNION ALL SELECT 2 AS 'Tag' ,1 AS 'Parent' ,NULL AS 'XML!1' ,RTRIM(Code) AS 'Company!2!Code' ,Name AS 'Company!2!Name' ,NULL AS 'Department!3!Code' ,NULL AS 'Department!3!Name' FROM Company UNION ALL SELECT 3 AS 'Tag' ,2 AS 'Parent' ,NULL AS 'XML!1' ,RTRIM(c.Code) AS 'Company!2!Code' ,NULL AS 'Company!2!Name' ,RTRIM(d.Code) AS 'Department!3!Code' ,d.Name AS 'Department!3!Name' FROM Company c INNER JOIN Department d ON.

Read more
  • פיתוח מערכות
  • פתרונות טכנולוגים
  • קידום אתרים
  • בניית אתרים