StackOverflow Questions for Tag: select-for-xml

Paul White

Reputation: 374

Generating self-closing XML tags for lists in SQL Server

sql-servert-sqlsql-server-2019for-xmlselect-for-xml

Score: 0

Answers: 4

Stefan Steiger

Reputation: 82306

How to put an attribute on the root element, and only the root element, in FOR XML PATH?

sqlsql-servert-sqlfor-xml-pathselect-for-xml

Score: 1

Answers: 3

PatsonLeaner

Reputation: 1250

SQL SERVER Select Distinct ID is not working

sqlsql-serverdistinctfor-xml-pathselect-for-xml

Score: 0

Answers: 2

Christian4145

Reputation: 543

TSQL: Return elements of a group as XML

sql-serverxmlt-sqlsql-server-2016select-for-xml

Score: 0

Answers: 1

Kesiya Abraham

Reputation: 853

SQL query for Dynamic nodes in XML

sqlsql-serverxmlfor-xml-pathselect-for-xml

Score: 2

Answers: 1

cyberspy

Reputation: 1087

Cross apply function returning XML needs a column name

sql-servert-sqlcross-applyfor-xmlselect-for-xml

Score: 0

Answers: 1

Tymur Lysenko

Reputation: 103

For xml path returns null instead of nothing

sql-serverxmlt-sqlfor-xml-pathselect-for-xml

Score: 3

Answers: 2

Joe

Reputation: 1055

SQL Server 2014 - FOR XML AUTO avoid automatic node nesting

sql-serverselect-for-xml

Score: 0

Answers: 2

Pavel Foltyn

Reputation: 409

SQL Server SELECT FOR XML How to get two elements at the same level

sql-serverselect-for-xml

Score: 3

Answers: 2

FMFF

Reputation: 1718

Using FOR XML PATH to output Multiple Sibling Elements

xmlt-sqlsql-server-2012for-xml-pathselect-for-xml

Score: 1

Answers: 1

John Adams

Reputation: 4833

Subquery in FROM clause is causing unwanted ELEMENT in FOR XML AUTO output

sql-serversql-server-2008t-sqlsubqueryselect-for-xml

Score: 0

Answers: 2

Neil Allen

Reputation: 13

Different values returned by SQL Server 2000 and SQL Server 2014 when returning results using for xml explicit

sqlsql-serverxmlfor-xml-explicitselect-for-xml

Score: 1

Answers: 2

v s

Reputation: 559

How to get rid of special characters after generating sql statements using for xml

sql-serverselect-for-xml

Score: -1

Answers: 1

jpierson

Reputation: 17384

How to output raw xml within an XML projection in SQL Server without introducing an extra xml root element

sql-serverxmlt-sqlselect-for-xml

Score: 2

Answers: 2

devloper

Reputation: 101

Grouping XML Elements in FOR XML Clause

sql-serverselect-for-xml

Score: 0

Answers: 1

Thomas Byrne

Reputation: 137

FOR XML SQL Server - Variable Element name in output XML

sql-serverxmlfor-xmlfor-xml-pathselect-for-xml

Score: 4

Answers: 2

allan

Reputation: 979

Select for xml statement to produce excel sheetData format

sql-servert-sqlopenxmlselect-for-xml

Score: 1

Answers: 1

TravelDuck

Reputation: 29

Specific XML layout needed

sql-servert-sqlselect-for-xml

Score: 1

Answers: 1

Ishpal

Reputation: 93

tsql for XML format the values as elements

sql-serverxmlpathfor-xml-pathselect-for-xml

Score: 0

Answers: 1

Brienne Schroth

Reputation: 2457

How can I convert a row with many columns to a table with two columns (fieldname and value) and many rows?

xmlsql-server-2008selectxfdfselect-for-xml

Score: 3

Answers: 3

PreviousPage 1Next