joining two tables and inserting a non-xml data type column into an xml data type column

• Barret-330682

  SSC Rookie

  Points: 27

  More actions

  July 5, 2011 at 1:03 pm

  #254000

  what is the syntax to insert a value from table 1 into a xml data type field in table2? Another words, adding to the field in table2 which is an xml data type, from the value of the field in table1.

• Orlando Colamatteo

  SSC Guru

  Points: 182293

  More actions

  July 5, 2011 at 3:45 pm

  #1348627

  You can use this when assigning the value to the column in your UPDATE statement:

  destination_column_name = CAST(source_column_name as XML)

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato