Question: Using the AdventureWorksDW2016CTP3 database. Select * from Person.Person Where FirstName = John For XML Auto. Click on the XML link in the results area to

Using the "AdventureWorksDW2016CTP3" database.

  1. Select * from Person.Person Where FirstName = John For XML Auto.
  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.
  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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

These are the instructions: Using the "AdventureWorksDW2016CTP3" database. Select * from Person.Person Where FirstName = John For XML Auto. Click on the XML link in the results area to open the XML...

Q:

I am attempting to answer #4, the screenshot represents what I am trying to do. I keep receiving error messages. What changes need to be made or what can I do to make the query run successfully?...

Q:

Execute the steps below in the SSMS query building using the "AdventureWorksDW2016CTP3" database. Select * from Person.Person Where FirstName = John For XML Auto (THIS WILL BE YOUR XML DATA). Click...

Q:

Need help learning how to export data from SQL in XML form and then importing that data back into SQL. I am using the AdventureWorks2016 data downloaded from...

Q:

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

Q:

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,"...

Q:

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

Q:

haa23684_PlugInT6CD.qxd 9/6/06 5:38 PM Page 2 CONFIRMING PAGES P L U G - I N T6 Basic Skills and Tools Using Access LEARNING OUTCOMES 1. Describe the primary functions using Microsoft Access. 2....

Q:

Hudson: Lisa: Fred: Jake: We've made a lot of progress researching various ERP vendors. However, ERP software for car dealerships is still fairly expensive for a small dealership like ours. Combine...

Q:

labism 5.8.5 Create a decision table based on the following case: Given a loan application, the officer may decide to either approve or deny it. First of all, the officer checks the applicant's...

Q:

Gina is interested in buying a house beside the university which she will rent to students. She expects to receive $1,200 a month in rental income (net of maintenance). Gina's real estate agent...

Q:

Consider the equation below. log4(x+3)= log (2+x) Which system of equations can represent the equation? log(x+3) log4 log(2+ x) .Y2 = log2 Y = y1= logx+3 log4 I O Y = Y2 = log4 log(x+3) = log2.2=...

Q:

The librarian at a university library in Norway conducts a survey to measure the students satisfaction regarding the librarys services. Across a period of 3 weeks, he interviews every 50th student...

Q:

Retailing is the primary activity in which of the following situations? Multiple Choice going to a lab for blood tests restocking a big - box store with paper towels from multiple suppliers...

Q:

=+What would you leave out to allow readers to share their wisdom?

Q:

=+Find two websites for (a) similar brands, (b) same-industry businesses, or (c) competing advertising agencies, digital agencies, or design firms.

Q:

=+What kinds of topics can you come up with to discuss? Could you create a contest?