how can I push xml data back to table?

Hi, I have a xml string that reveived from select ... for xml auto in sql
server 2005, now how can I push these xml data back to another sql server
database table? Thx a lot.
Risen
Hello Risen,
R> Hi, I have a xml string that reveived from select ... for xml auto
R> in sql server 2005, now how can I push these xml data back to another
R> sql server database table? Thx a lot.
In SQL 2000 or 2005, look into OPENXML.
In 2005, you also have the option of using the XML datatype and the nodes
function or using SSIS or writing your own SQLCLR parser.
Lots of ways to skin that Cat. The Cat won't like any of them. :X
Thanks,
Kent Tegels
http://staff.develop.com/ktegels/
|||Thanks : )
"Kent Tegels" <ktegels@.develop.com>
?:b87ad74ba118c8c096c4c89b30@.news.microsoft.c om...
> Hello Risen,
> R> Hi, I have a xml string that reveived from select ... for xml auto
> R> in sql server 2005, now how can I push these xml data back to another
> R> sql server database table? Thx a lot.
> In SQL 2000 or 2005, look into OPENXML.
> In 2005, you also have the option of using the XML datatype and the nodes
> function or using SSIS or writing your own SQLCLR parser.
> Lots of ways to skin that Cat. The Cat won't like any of them. :X
> Thanks,
> Kent Tegels
> http://staff.develop.com/ktegels/
>
>
|||You can also use Xml Bulkload functionality.
See more on this :http://msdn2.microsoft.com/en-us/library/ms171993.aspx
Regards,
Monica Frintu
"Risen" wrote:

> Thanks : )
>
> "Kent Tegels" <ktegels@.develop.com>
> ?:b87ad74ba118c8c096c4c89b30@.news.microsoft.c om...
>
>