SYM WK3

XML Basics Application

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

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 AdventureWorks2017 database and select New Query.

Execute the following steps:

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

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

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

4. 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)

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

Rubric Criteria

Expand All Rubric CriteriaExpand All

Select Statement and Result Window Screenshot and One-Line Description

19.5 points

xmlTest File Screenshot and One-Line Description

13 points

SQL Transaction Code and Results Screenshot and One-Line Description