Create a table with a untype XML column

• Create a table with a untype XML column
  
  CREATE TABLE X
  {
           [XID] [int] NOT NULL,
           [XINFO] [xml] NOT NULL
  } ON [PRIMARY]
  GO
• Insert into an untyped XML data type column
  DECLARE @xmlvar varchar[100]
  SET @xmlvar =
  '<NODETAG>
             <A>abc</A>
             <B>xyz</B>
  </NODETAG>'
  
  INSERT INTO NODETAG (XID,XINFO) values (1, @xmlvar)
  GO. 

<<Previous   Next>>