Which code segment should you develop?

You plan to create a stored procedure that inserts data from an XML file to the OrderDetails table. The following is the signature of the stored procedure:


The following is the XSD file used to create the ValidateOrder schema collection:


You develop a code segment that retrieves the number of items and loops through each item. Each time the loop runs, a variable named @itemNumber is incremented.
You need to develop a code segment that retrieves the product ID of each item number in the loop.
Which code segment should you develop?
A. SET @productID = @items.value’/Root/Product/productID’, int)
B. SET @productID = @items.value’/Root/Product[‘+ @itemNumber+ ‘]/@productID’, int)
C. SET @productID = @items.value’/Root/Product[‘+ @itemNumber+ ‘]/productID’, int)
D. SET @productID = @items.value’/Root/Product/@productID’, int)

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.