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)$

APA style is not required, but solid academic writing is expected.

This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.

You are not required to submit this assignment to LopesWrite.