Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Xml Excercise 2
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;
run
|
edit
|
history
|
help
0
practice sql_12AUG
20181117
Loan table
Miglior film animato
Stuff
tt
Demo
Names
sqlserver
20181CSE0041