Discussion
The expression FOR XML RAW tells SQL Server to:
Answer: A
Correct answer: place the values of the columns as attributes in the resulting XML document.
FOR XML RAW produces one generic row element per row with the column values as attributes of it. FOR XML AUTO uses table names as elements, and FOR XML EXPLICIT gives complete control over the shape, letting some columns become elements and others attributes at the cost of a much more elaborate query.
No comment is present. Be the first to comment.
Loading…
Post your comment
Please log in or register to post a comment.
Examination Categories
- SSC Exams
- Banking Exams
- Teaching Exams
- Civil Services Exams
- Railways Exams
- Engineering Recruitment Exams
- Defence Exams
- State Government Exams
- Police Exams
- Insurance Exams
- Nursing Exams
- Other Government Exams
- NRA CET
- PG Entrance Exams
- Campus Placement
- MBA Entrance Exams
- CUET and UG Entrance
- Judiciary Exams
- Regulatory Body Exams
- Software Development