Run Code
|
Code Wall
|
Users
|
Misc
|
Feedback
|
About
|
Login
|
Theme
|
Privacy
Xml Excercise 2
Language:
Ada
Assembly
Bash
C#
C++ (gcc)
C++ (clang)
C++ (vc++)
C (gcc)
C (clang)
C (vc)
Client Side
Common Lisp
D
Elixir
Erlang
F#
Fortran
Go
Haskell
Java
Javascript
Kotlin
Lua
MySql
Node.js
Ocaml
Octave
Objective-C
Oracle
Pascal
Perl
Php
PostgreSQL
Prolog
Python
Python 3
R
Ruby
Scala
Scheme
Sql Server
Swift
Tcl
Visual Basic
Editor:
CodeMirror
EditArea
Simple
Layout:
Vertical
Horizontal
CREATE TABLE Sales (EmpId INT, Yr INT, price MONEY) INSERT Sales VALUES(1, 2005, 12000) INSERT Sales VALUES(1, 2006, 18000) INSERT Sales VALUES(1, 2007, 25000) INSERT Sales VALUES(2, 2005, 15000) INSERT Sales VALUES(2, 2006, 6000) INSERT Sales VALUES(3, 2006, 20000) INSERT Sales VALUES(3, 2007, 24000) select * from sales order by empid for xml raw,elements,root('customers'); DECLARE @x AS XML; SET @x=N' <root> <a>1<c>3</c><d>4</d></a> <b>2</b> </root>'; SELECT @x.query('*') AS Complete_Sequence, @x.query('data(*)') AS Complete_Data, @x.query('data(root/a/c)') AS Element_c_Data;
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