TechQA.

Question

Generating self-closing xml tags for lists in SQL Server

score 291 · Answer 1 · 2022-08-18T11:34:55.387000

0

Answer

291

Views

Generating self-closing xml tags for lists in SQL Server

291 views Asked by Paul White At 18 August 2022 at 11:34

score 423 · Answer 2 · 2020-12-08T11:25:53.557000

SQL SERVER Select Distinct ID is not working

423 views Asked by PatsonLeaner At 08 December 2020 at 11:25

score 809 · Answer 3 · 2020-06-25T11:59:35.193000

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

809 views Asked by Stefan Steiger At 25 June 2020 at 11:59

score 79 · Answer 4 · 2020-03-19T16:37:28.760000

TSQL: Return elements of a group as XML

79 views Asked by Christian4145 At 19 March 2020 at 16:37

score 383 · Answer 5 · 2018-11-29T16:18:00.667000

Cross apply function returning XML needs a column name

383 views Asked by cyberspy At 29 November 2018 at 16:18

score 1799 · Answer 6 · 2018-05-17T15:14:20.443000

For xml path returns null instead of nothing

1.7k views Asked by Tymur Lysenko At 17 May 2018 at 15:14

score 146 · Answer 7 · 2017-07-17T13:51:22.150000

SQL Server 2014 - FOR XML AUTO avoid automatic node nesting

146 views Asked by Joe At 17 July 2017 at 13:51

score 4675 · Answer 8 · 2017-04-12T21:36:58.387000

Using FOR XML PATH to output Multiple Sibling Elements

4.6k views Asked by FMFF At 12 April 2017 at 21:36

score 1405 · Answer 9 · 2017-03-09T13:49:56.457000

SQL query for Dynamic nodes in XML

1.4k views Asked by Kesiya Abraham At 09 March 2017 at 13:49

score 135 · Answer 10 · 2017-01-07T00:01:14.273000

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

135 views Asked by John Adams At 07 January 2017 at 00:01

score 131 · Answer 11 · 2016-06-22T18:49:50.110000

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

131 views Asked by Neil Allen At 22 June 2016 at 18:49

score 101 · Answer 12 · 2015-09-22T14:45:22.613000

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

101 views Asked by v s At 22 September 2015 at 14:45

score 137 · Answer 13 · 2015-04-28T16:44:02.453000

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

137 views Asked by jpierson At 28 April 2015 at 16:44

score 164 · Answer 14 · 2015-03-19T01:24:15.600000

Grouping XML Elements in FOR XML Clause

164 views Asked by devloper At 19 March 2015 at 01:24

score 2258 · Answer 15 · 2014-10-06T12:12:56.420000

FOR XML SQL Server - Variable Element name in output XML

2.2k views Asked by Thomas Byrne At 06 October 2014 at 12:12

score 2649 · Answer 16 · 2014-05-23T07:26:44.297000

Select for xml statement to produce excel sheetData format

2.6k views Asked by allan At 23 May 2014 at 07:26

score 4970 · Answer 17 · 2014-05-21T16:07:23.030000

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

4.9k views Asked by Pavel Foltyn At 21 May 2014 at 16:07

score 80 · Answer 18 · 2013-11-20T10:56:26.477000

Specific XML layout needed

80 views Asked by TravelDuck At 20 November 2013 at 10:56

score 318 · Answer 19 · 2013-10-15T18:44:03.000000

tsql for XML format the values as elements

318 views Asked by Ishpal At 15 October 2013 at 18:44

score 1906 · Answer 20 · 2013-02-01T17:32:28.913000

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

1.9k views Asked by Brian Schroth At 01 February 2013 at 17:32

TechQA.

List Question

Generating self-closing xml tags for lists in SQL Server

SQL SERVER Select Distinct ID is not working

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

TSQL: Return elements of a group as XML

Cross apply function returning XML needs a column name

For xml path returns null instead of nothing

SQL Server 2014 - FOR XML AUTO avoid automatic node nesting

Using FOR XML PATH to output Multiple Sibling Elements

SQL query for Dynamic nodes in XML

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

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

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

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

Grouping XML Elements in FOR XML Clause

FOR XML SQL Server - Variable Element name in output XML

Select for xml statement to produce excel sheetData format

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

Specific XML layout needed

tsql for XML format the values as elements

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

Popular Questions

Trending Questions