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