MS SQL XML - HOW I CAN SAVE AN XML IN SQL SERVER

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 I CAN SAVE AN XML IN SQL SERVER

GRS

2005-07-18, 8:24 pm

I HAVE AN APP THAT RECEIVE FROM THE WEB A XML FILE
I NEED TO SAVE AS A TABLE IN SQL SERVER
CAN ANYBODY HELP ME ??

THANKS
GRS

Bertan ARI [MSFT]

2005-07-18, 8:24 pm

Do you want to shred it into rows/columns or store it as blob?

If you want to shred it, you may use OpenXML or Dataset. If the file size is
big, consider using Bulkload which will stream the date to SQL server.

--
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.

"GRS" <g_saturansky@yahoo.com> wrote in message
news:1121727965.861690.60780@g47g2000cwa.googlegroups.com...
>I HAVE AN APP THAT RECEIVE FROM THE WEB A XML FILE
> I NEED TO SAVE AS A TABLE IN SQL SERVER
> CAN ANYBODY HELP ME ??
>
> THANKS
> GRS
>

Sponsored Links