SELECT an Xml variable into a table

Question

I have a variable called result of type Xml that contains one cell of Xml text. I cannot seem to use SELECT INTO to insert this value into another temp table.

SELECT @result
INTO dbo.xml_temp

Is there a way to achieve this?

@LukStorms you mean something like SELECT @result AS XmlOutput? — disasterkid
– disasterkid, Commented Feb 2, 2017 at 8:47

Gottfried Lesigang · Accepted Answer · 2017-02-02 11:28:53Z

3

If you want to insert the XML into an existing table, you have

VALUES
or INSERT INTO ... SELECT ...:

Try this:

DECLARE @tbl TABLE(ID INT IDENTITY,TargetColumn XML);

DECLARE @SomeXML XML ='<root>test</root>';

INSERT INTO @tbl VALUES(@SomeXML);

INSERT INTO  @tbl(TargetColumn) SELECT @SomeXML;

SELECT * FROM @tbl;

If you really want to create a new temp table, your statement is just missing an alias (How should the new table know the column's name?):

SELECT @SomeXML AS SomeName INTO #tmpTable;
SELECT * FROM #tmpTable;

edited Feb 2, 2017 at 11:28

answered Feb 2, 2017 at 9:38

Gottfried Lesigang

67.6k9 gold badges60 silver badges124 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SELECT an Xml variable into a table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related