getting xml data

Hello there

I have some store procedures who execute XML.

I would like to run them and store the XML in table, variable.

how can i do that?

On Aug 25, 4:56 am, "Roy Goldhammer" wrote:
> Hello there
>
> I have some store procedures who execute XML.
>
> I would like to run them and store the XML in table, variable.
>
> how can i do that?

Roy

You could treat the Xml like any other data type and store it. For
example:

DECLARE @Data xml

SET @Data = (SELECT *
FROM SourceTable
WHERE ID = 101 FOR XML Auto, Type)

INSERT INTO TargetTable (MyXml) VALUES (@Data)

Hope this helps

Carl