[SQL]將查詢出來的表格轉成XML-FOR XML

將查詢出來的表格轉成XML-FOR XML

SELECT 1 AS A00,

NhiType AS A01,

1.0 AS A02

FROM NhiICCardRecord

WHERE NhiNo = 1

FOR XML PATH ('REC')

SELECT執行後，就會直接產生可點開的XML

產生的XML內文就是以REC為根目錄，每個欄位就各為TAG