Xml Excercise 2, Sql Server - rextester

Run Code | API | Code Wall | Misc | Feedback | Login | Theme | Privacy | Patreon

Xml Excercise 2

Language: Layout:

View schema
Execution time: 0.31 sec, rows selected: 9, rows affected: 7, absolute service time: 0.48 sec

edit mode | history | discussion

  
XML_F52E2B61-18A1-11d1-B105-00805F49916B

1
<customers><row><EmpId>1</EmpId><Yr>2005</Yr><price>12000.0000</price></row><row><EmpId>1</EmpId><Yr>2006</Yr><price>18000.0000</price></row><row><EmpId>1</EmpId><Yr>2007</Yr><price>25000.0000</price></row><row><EmpId>2</EmpId><Yr>2005</Yr><price>15000.0000</price></row><row><EmpId>2</EmpId><Yr>2006</Yr><price>6000.0000</price></row><row><EmpId>3</EmpId><Yr>2006</Yr><price>20000.0000</price></row><row><EmpId>3</EmpId><Yr>2007</Yr><price>24000.0000</price></row></customers>


  
Complete_Sequence
Complete_Data
Element_c_Data

1
<root><a>1<c>3</c><d>4</d></a><b>2</b></root>
1342
3

λ

                                      .NET NoSQL database for rapid development