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
SQL Server NULL replacement with dynamic value
exp 8 XIV
Max from multiple columns
SQL HW 1 Appline
Tucha Alexander DB QA Test Tasks Answers
EXP 8
2021-03-23_LeetCodeSQL
Student
mysql4
ex2