Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Getting a handle on XML

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-06-11 : 21:43:18
Alan D. Nelson writes "I want to use SQL Server 2000 to generate some XML... and I would like to store this XML in another table. I'd like to do all of this with a stored procedure....

Basically, I'd like to get the result of:

SELECT * FROM TABLE FOR XML AUTO

And put that result string into the column of some other table.

I just can't seem to get a handle on the XML.

Help?"
   

- Advertisement -