Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sateesh.sqldba
Starting Member
25 Posts |
 Posted - 2010-10-31 : 07:24:23
|
| Hi Experts,would please tel me the way how to insert this style sheet into table<?xml version="1.0" encoding="utf8" ?> <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchemainstance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Header><wsu:Timestamp xmlns:wsu="http://schemas.xmlsoap.org/ws/2002/07/utility"><wsu:Created>20090312T11:23:02Z</wsu:Created> <wsu:Expires>20090312T11:28:02Z</wsu:Expires> </wsu:Timestamp></soap:Header><soap:Body><GetAvailableToursXMLResponse xmlns="http://webapi.globusandcosmos.com/"><GetAvailableToursXMLResult xmlns="http://webapi.globusandcosmos.com/AvailableTours.xsd"><Tours><Tour><TourNumber>BYC</TourNumber> <Brand>COSMOS</Brand> <Name>COSTA DEL SOL</Name> </Tour><Tour><TourNumber>BYD</TourNumber> <Brand>COSMOS</Brand> <Name>CROATIA</Name> </Tour><Tour><TourNumber>BYDU</TourNumber> <Brand>COSMOS</Brand> <Name>CROATIA WITH SEAVIEW ROOMS</Name> </Tour><Tour><TourNumber>BYE</TourNumber> <Brand>COSMOS</Brand> <Name>ESTORIL COAST & THE ALGARVE</Name> </Tour><Tour><TourNumber>BYF</TourNumber> <Brand>COSMOS</Brand> <Name>COSTA RICA</Name> </Tour></Tours></GetAvailableToursXMLResult></GetAvailableToursXMLResponse></soap:Body></soap:Envelope>i want TourNumber,Brand,Name into my sql table please help me outThankssateeshsateesh |
|
|
|
|
|
Xml style sheet data into table