Write a script that uses the XML document shown below to update the contact information in the Vendors table.
McCrystle
Timothy
Flynn
Erin
To accomplish this, begin by storing this XML document in a variable of the XML type. Then, you can use two UPDATE statements to update the Vendors table.
Write a script that returns a result set that contains all of the data stored in the XML document in the above statement.