XML : Remove Root XML nodes from default output of Sql Server statement

I want @MyActualXMLOut to look like @MyDesiredXMLOut... How? Thanks in advance!

@MyDesiredXMLOut =

  <MyRequiredRoot>    <Property1>Value1</Property1>    <Property2>Value2</Property2>  </MyRequiredRoot>    

@MyActualXMLOut

  <_x0040_MyTableVar>    <MyXML>      <MyRequiredRoot>        <Property1>Value1</Property1>        <Property2>Value2</Property2>      </MyRequiredRoot>    </MyXML>  </_x0040_MyTableVar>    

The code below can be run as is...

  DECLARE @MyDesiredXMLOut XML;  DECLARE @MyActualXMLOut XML;    SELECT @MyDesiredXMLOut =     CONVERT( XML,      '<MyRequiredRoot><Property1>Value1</Property1>        <Property2>Value2</Property2>      </MyRequiredRoot>' );    DECLARE @MyTableVar table( ID int NOT NULL, MyXML XML NOT NULL );    INSERT INTO @MyTableVar VALUES( 1, @MyDesiredXMLOut )    SELECT @MyActualXMLOut =       ( SELECT MyXML        FROM   @MyTableVar        WHERE  ID = 1        FOR XML AUTO )    SELECT @MyDesiredXMLOut;    SELECT @MyActualXMLOut;    

No comments:

Post a Comment