(Please don’t copy and paste from other answers for thisquestion on here)
Write a script that returns a result set that contains all ofthe data stored in the NewCustomers.xml file that’s in the ExerciseStarts directory.
To accomplish this, begin by storing the contents of the XML filein a variable of the XML type. Then, you can use a SELECT statementto return the data stored in this variable as a result set.
NewCustomers.xml file:
<NewCustomers>
<Customer EmailAddress=”izzychan(at)yahoo.com” Password=””FirstName=”Isabella” LastName=”Chan” />
<Customer EmailAddress=”johnprine(at)g-mail.com” Password=””FirstName=”John” LastName=”Prine” />
<Customer EmailAddress=”kathykitchen(at)sbcglobal.net”Password=”” FirstName=”Kathy” LastName=”Kitchen” />
</NewCustomers>
Expert Answer
An answer will be send to you shortly. . . . .