The purpose of this assignment is to explain XML concepts and the appropriate use of XML$.$

View the $"$XML Basics" video within the "Video Playlist: Relational Databases for Business Applications," located in the topic Resources.

The IT department is rolling out a new product application for the marketing department and has requested your expertise in addressing some questions related to an upcoming project: IT is exploring inputting data from SQL Server through XML$.$

Start the VM$,$ and inside the VM$,$ click Start, type SSMS $($to open SQL Server Management Studio$),$ and connect to the instance. Select Databases, then right$-$click on the AdventureWorks$2017$ database and select New Query.

Execute the following steps:

Select $*$ from Person.Person Where FirstName $=$ 'John' For XML path. Take a screenshot of the Select statement and the result window.

Click on the XML link in the results area to open the XML view.

Right$-$click on the SSMS query tab above the view and save the file as "xmlTest.xml$."$ Take a screenshot of the file.

Construct a SQL transaction to import the "xmlTest.xml$"$ results file back into SQL Server. Hint: Use the Commands OPENROWSET and OPENXML and the two stored procedures $"$sp$\_$xml$\_$preparedocument" and $"$sp$\_$xml$\_$removedocument". Take a screenshot of your SQL transaction code and its result. $($Result should be a display of all "John" values in Person.Person.$)$

Submit the following in a single document compatible with the digital classroom $($e$.$g$.,$ Microsoft Word$).$ Include a one$-$line description above each screenshot.

Screenshot$($s$)$ of Select statement and result window $($#$1)$

Screenshot of the xmlTest file $($#$3)$

Screenshot of SQL transaction code from SMSS and results of executing transaction code $($#$4)$