Hi,
As biztalk developer, when in begining of developing you may face problem understanding what is difference between FOR XML AUTO,XMLDATA and ELEMENTS.
here in this note i’ll explain you one by one.
- FOR XML AUTO : is used to represent the actual data in xml format.
- FOR XML AUTO , XMLDATA : is used to represent the actual data in xml format while generatiing schema.
- FOR XML AUTO , ELEMENTS : is used to represent the actual data in xml element type which is most suggested method of generating of xml from SQL.
- FOR XML EXPLICIT : is used to generate complicated XML message where you want result from different tables at that time you can format the result set in correct XML structure via FOR XML Explicit.
for simplify to understand the above please feel free to mail me(vkas_in_guj@hotmail.com) or post me.
Happy coding,
Vikas.
