|
Home > Archive > MS SQL XML > October 2006 > how can I push xml data back to table??
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
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
| |
| Kent Tegels 2006-10-24, 6:49 pm |
| 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>
?????? :b87ad74ba118c8c096c
4c89b30@news.microsoft.com...
> 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/
>
>
>
| |
| Monica Frintu [MSFT] 2006-10-24, 6:49 pm |
| 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>
> ?????? :b87ad74ba118c8c096c
4c89b30@news.microsoft.com...
>
>
>
|
|
|
|
|