Learn T-SQL Commands with Samples
Skip Navigation Links
Skip Navigation Links.
Expand DatabaseDatabase
Expand TableTable
Expand ViewView
Expand Stored ProcedureStored Procedure
Expand Data FilteringData Filtering
Expand Data GroupingData Grouping
Expand JoinsJoins
Expand TriggerTrigger
Expand CursorCursor
Expand OperatorsOperators
Expand ConstraintsConstraints
Expand FunctionsFunctions
Expand Conditional ProcessingConditional Processing
Expand LoopingLooping
Expand Error HandlingError Handling
Expand v.IMP Queriesv.IMP Queries
Collapse XMLXML
Expand Query PerformanceQuery Performance
Expand QueriesQueries
Expand NormalizationNormalization
Expand CreateCreate
     

XML

 
* Raw : FOR XML RAW, generates generic row elements with column values as attributes.

* Auto : FOR XML AUTO, generates a hierarchical tree with element names based on table names.

* Explicit : FOR XML EXPLICIT, Transforms the rowset that results from the query execution into an XML document.

* Path : FOR XML PATH, column names or column aliases are treated as XPath expressions.