[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Fw: XSLT & SQL
----- Original Message ----- From: "E L" <pappis3d@xxxxxxxxxxxx> To: <abcoates@xxxxxxxxxxxxx> Sent: Thursday, July 11, 2002 1:45 PM Subject: Re: XSLT & SQL > Presumably, a tool will be written to take any XSLT script and generate the > equivalent insert SQL statement together with the table definitions (for now > assume input and output are XML and the schemas for them will also be input > to the tool). > > ----- Original Message ----- > From: "Anthony B. Coates" <abcwww@xxxxxxxxxxxxxxxxxxx> > To: <pappis3d@xxxxxxxxxxxx> > Sent: Thursday, July 11, 2002 1:39 PM > Subject: Re: XSLT & SQL > > > > > Someone told me that he can do *any* XSLT transformation in SQL. Here's > the > > > premise: any input XML document can be represented by one or more > tables; > > > likewise for the output XML document. The XSLT can be replaced with an > SQL > > > insert statement, selecting from the input and inserting to the output > > > (e.q., any XPath expression can be expressed by a similar WHERE clause > in a > > > SELECT statement). > > > > > > I can see it's possible for simple document. Are there instances where > this > > > would not be possible? > > > > No, it's always possible to do it in SQL, just as it is always possible to > do it in assembly language. The question is whether it is worth spending > the time to write the SQL code. There will be some cases where it takes > less time to write the SQL, and some cases where it takes less time to write > the XSLT. Development time tends to be more of an issue these days than raw > speed, which is important to remember. > > > > Cheers, > > Tony. > > > > ======== > > Anthony B. Coates > > Financial XML Specialist > > mailto:abcoates@xxxxxxxxxxxxx > > > > _______________________________________________________________________ > > Freeserve AnyTime, only £13.99 per month with one month's FREE trial! > > For more information visit http://www.freeserve.com/time/ or call free on > 0800 970 8890 > > > > > XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|