XML transform to SQL by XSL
-
i have this xml here, and now i would like to use xsl to transform into sql statement like this: update OrderDetails set Quantity = 2 where OrderID = 10248 and ProductID = 11 Here is the XML document: 2 Here is a bit i did: update as i am still new in this field, can someone guide me through? Many thanks
-
i have this xml here, and now i would like to use xsl to transform into sql statement like this: update OrderDetails set Quantity = 2 where OrderID = 10248 and ProductID = 11 Here is the XML document: 2 Here is a bit i did: update as i am still new in this field, can someone guide me through? Many thanks
AndieDu wrote:
as i am still new in this field, can someone guide me through?
Make sure the Database product you are using does not have it's own facility to import XML before you go creating SQL statements, most of the major products support that.
led mike
-
AndieDu wrote:
as i am still new in this field, can someone guide me through?
Make sure the Database product you are using does not have it's own facility to import XML before you go creating SQL statements, most of the major products support that.
led mike
-
AndieDu wrote:
in here actually i need a example
http://www.google.com/search?hl=en&q=SQLXML&btnG=Search[^]
led mike