Inserting XML data into an XML column from the Data Project Explorer

You can use the Insert into XML Column wizard to insert XML data into an XML column. You can open the wizard from XML files or folders that are stored in a data development project.
Prerequisites: Before you can complete the wizard, you must complete the following prerequisite steps:

To insert XML data into an XML column from the Data Project Explorer:

  1. Select an XML folder or one or more XML files that are contained in a data development project in the Data Project Explorer.
  2. Right-click, and select Insert into XML Column. The Insert into XML Column wizard opens.
  3. Complete the steps of the wizard, then click Finish. You can select an XML column to insert the data, and you can optionally select an XML schema to validate the insert. For additional help about the wizard, press F1.
The data from the XML files that you selected is inserted into the XML column. You can view the results of the actions in the Data Output view, including any errors or failures. Each insert is performed separately, so if you are performing multiple inserts at the same time, the success or failure of each insert is displayed. You can also view a sample of the data that was inserted by right-clicking the XML column in the Database Explorer, and selecting Data > Sample Contents.

Feedback