利用SQL生成xml示例

/*
利用SQL生成xml示例
*/


/*显示空的字段*/
SELECT TOP 1 PatName,PAT.PatID,PID.ImageNo,PAT.RegPatID
FROM Patient AS PAT INNER JOIN(SELECT PATID,PatNumber AS ImageNo FROM  PatientIdentify WHERE NTypeCode='0003') AS PID ON PAT.PatID=PID.PatID
WHERE PatOtherName LIKE 'YIN%' FOR XML RAW('Patient'),ELEMENTS XSINIL,ROOT('ROWDATA')




/*不显示空的字段*/
SELECT TOP 1 PatName,PAT.PatID,PID.ImageNo,PAT.RegPatID
FROM Patient AS PAT INNER JOIN(SELECT PATID,PatNumber AS ImageNo FROM  PatientIdentify WHERE NTypeCode='0003') AS PID ON PAT.PatID=PID.PatID
WHERE PatOtherName LIKE 'YIN%' FOR XML RAW('Patient'),ELEMENTS ,ROOT('ROWDATA')




/*lqy 1.FOR XML RAW('Patient')*/
select top 1
 PAT.PatID, PAT.PatName, PAT.PatOtherName, PAT.Birthday, PAT.Iden