Inserting XML data into an XML column from the Database Explorer

You can use the Insert into XML Column wizard to insert XML data into an XML column. You can open the wizard from an XML column that is displayed in a database connection in the Database Explorer.
Prerequisites: Before you can complete the wizard, you must complete the following prerequisite steps:

To insert XML data into an XML column from the Database Explorer:

  1. Select one XML column in the Database 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 XML files from the file system to insert into the XML column, 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