Re: HOW I CAN SAVE AN XML IN SQL SERVER

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@xxxxxxxxx> wrote in message
news:1121727965.861690.60780@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>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
>


.

Relevant Pages

  • Re: What is fastest way to insert many records into a SQL server database?
    ... To use OPENXML do I have to output an XML file to be imported by SQL Server ... (in much the same way as the BULK INSERT method) ...
    (microsoft.public.dotnet.languages.csharp)
  • XML file to SQL Server table - best way?
    ... We'd like to get the results out of the XML file and get them into a table ... As far as I know the software on the testers does not have ... the ability to directly transfer the data into SQL server. ... location the SQL server can 'see' so it can access and parse the file. ...
    (microsoft.public.sqlserver.xml)
  • Re: 1.5 MB input file generates 940MB of data in BizTalkMsgBoxDb
    ... I ran the following interchange on an XML file I worked on a while back: ... Initial Size of Msgbox DB Sql Data File -> 35 MB ... Size of files read from Sql Server Management Studio (Database properties ... Look at the Sql Server Agent jobs set up by Biztalk. ...
    (microsoft.public.biztalk.general)
  • Re: extracting results of XML stored proc to file
    ... extended Stored Proc or something, but it'd be a lot of effort.) ... Agent job and execute it from within SQL Server. ... 'Assign the output stream. ... extract them from the results into an XML file ...
    (microsoft.public.sqlserver.xml)
  • Re: Store File in SQLServer via ADO
    ... "William Vaughn" wrote: ... > with a convoluted file structure. ... > BLOB to a local temp file which slows the process even further. ... Does one need a SQL Server license to get to it? ...
    (microsoft.public.data.ado)