Question

using sql do the following

Write a script that uses the XML document shown below to update the contact information in the Vendors table.

<ContactUpdates>
<Contact VendorID="2">
    <LastName>Stanley</LastName>
    <FirstName>Henry</FirstName>
</Contact>
<Contact VendorID="12">
    <LastName>Ono</LastName>
    <FirstName>Santa</FirstName>
</Contact>
</ContactUpdates>

Answer 1

Here I am providing the answer for the above question:

Script:

UPDATE Vendors SET LastName="Stanley" , FirstName="Henry" WHERE VendorID=2;

UPDATE Vendors SET LastName="Ono" , FirstName="Santa" WHERE VendorID=12;

Hoping that the above answer will help you...Thank you...