Hi all, Are there many people out there storing XML docs or Fragments in SQL server 2000? Our current production DB is SQL 7 but I was wondering about the XML support in SQL Server. I was looking at the Books Online for SQL server 2000, and there seems to be a good bit of support for XML, however it would seem to me on first looks that most of the support is for either generating XML from records, Importing XML like Matt was doing, and XML/Xpath queries via the URL / IIS.
There doesn't seem to be support for Searching for elements/attributes in XML fragments/docs stored in text, varchar fields. Is it even possible to do Xpath using T-Sql ? Is anyone doing this out there? Can anyone point me to articles / knowledge base etc. dealing with this? Thanks Justin > -----Original Message----- > From: Matt Horn [mailto:[EMAIL PROTECTED]] > Sent: 13 September 2002 11:32 > To: [EMAIL PROTECTED] > Subject: Re: [ cf-dev ] XML + SQL problems > > > the solution is not to pass the empty XML elements > > <element> > <child>1</child> > <child>2</child> > <child>4</child> > <child></child> > </element> > > > basically you DON't put in > <child></child> > > > and it works fine > > *grumble* > > > At 11:23 13/09/02 +0100, you wrote: > >Tried -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
