What will be the output of the following scripts?
DECLARE @xml XML,@hdoc INT SELECT @xml = '<myxml> <value id = "1" name = "SQL Server"> <category>2</category> </value> <value id = "2" name = "Oracle"> <category>3</category> </value> </myxml>' EXEC sp_xml_preparedocument @hdoc OUTPUT, @xml SELECT DISTINCT category FROM OPENXML (@hdoc, '/myxml/value',1) WITH (id INT, name VARCHAR(10), category INT) EXEC sp_xml_removedocument @hdoc
A. NULL
B. 3,2
C. 2,3
D. Error: Incorrect syntax near /value
Answer:[A]
Highlight to find out the answer.
No comments:
Post a Comment