Re: Limitations of OPENXML support in SQL Server
From: John Kotuby (jkotuby_at_snet.net)
Date: 07/20/04
- Next message: Brian Jorgenson: "Import Data into XML"
- Previous message: TW: "XSD to SQL tables"
- In reply to: SriSamp: "Re: Limitations of OPENXML support in SQL Server"
- Next in thread: John Kotuby: "Re: Limitations of OPENXML support in SQL Server"
- Reply: John Kotuby: "Re: Limitations of OPENXML support in SQL Server"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 20 Jul 2004 11:24:18 -0400
Thanks SriSamp...
Back to the books I guess. I have heard this technology mentioned more than
once and will investigate it further.
"SriSamp" <ssampath@sct.co.in> wrote in message
news:%23oTKtDfbEHA.1152@TK2MSFTNGP09.phx.gbl...
> Check out if SQLXML can help you out. SQLXML moves the XML management out
of
> SQL Server and helps you write the same in the application layer.
> Check out:
>
http://www.microsoft.com/downloads/details.aspx?FamilyId=4C8033A9-CF10-4E22-8004-477098A407AC&displaylang=en
> --
> HTH,
> SriSamp
> Please reply to the whole group only!
> http://www32.brinkster.com/srisamp
>
> "John Kotuby" <jkotuby@snet.net> wrote in message
> news:uiK77WdbEHA.1248@TK2MSFTNGP11.phx.gbl...
> > I have spent considerable time creating an ASP page that uses ADO and a
> very
> > complicated FOR XML EXPLICIT query to create an XML data stream and send
> it
> > to a remote browser. The XML created is almost always greater than 8000
> > characters Here is where the problem(s) begin for me.
> >
> > I have experience with using VB, VBScript, ADO and Transact SQL, in
> > programming solutions, but not using XML as a data source. I need to
find
> a
> > way to get that XML data into existing SQL tables. I will be programming
> in
> > VB (using a browser control). The XML data is from several (8) related
> > tables. I have shaped the XML so that the Elements represent the tables
> and
> > the Attributes represent the field values of the columns.
> >
> > I was planning to use OPENXML with an Xpath pattern (such as
> > '/root/customers/orders') to open the data specific to a particular
table
> > and then update or insert records as necessary.
> >
> > However any OPENXML examples I see are used in concert with
> > "sp_xml_preparedocument @hdoc OUTPUT, @doc", and we know that the
maximum
> > size for a local SQL variable is 8000 chars.
> >
> > So here I am with a complete streamed XML document in my Browser control
> in
> > memory. Is there a way to get a file handle from this "stream" to pass
to
> > OPENXML?
> >
> > If not, maybe I should just pass the XML as a file to the browser and
have
> > the program save it to a predefined location. But, once again the
document
> > will be larger than 8k. I have seen no example that allows passing of a
> file
> > name to sp_xml_preparedocument.
> >
> > I have seen SQLXMLBulkLoad used by passing a schema filename and a data
> > filename. Maybe I can create staging tables to hold the results of the
> bulk
> > load and then process the data from there.
> >
> >
> >
>
>
- Next message: Brian Jorgenson: "Import Data into XML"
- Previous message: TW: "XSD to SQL tables"
- In reply to: SriSamp: "Re: Limitations of OPENXML support in SQL Server"
- Next in thread: John Kotuby: "Re: Limitations of OPENXML support in SQL Server"
- Reply: John Kotuby: "Re: Limitations of OPENXML support in SQL Server"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
