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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Read xml file

Author  Topic 

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2009-01-27 : 06:05:32
Hello,
Using SQL, how is it possible to read the contents of an xml file please?
Thanks

AvanthaSiriwardana
Yak Posting Veteran

78 Posts

Posted - 2009-01-27 : 06:13:58
Hi
you can use xml with SQL by providing the xmlroot with its child nodes.
please follow this link for more details and i think it will help you alot.
let me know





Avantha Siriwardana
Go to Top of Page

AvanthaSiriwardana
Yak Posting Veteran

78 Posts

Posted - 2009-01-27 : 06:15:09
sorry
forgot to mention the link.

http://msdn.microsoft.com/en-us/library/ms345117.aspx



Avantha Siriwardana
Go to Top of Page

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2009-01-27 : 07:17:17
Thank you
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-27 : 09:11:47
did you mean this?

http://msdn.microsoft.com/en-us/library/ms191184.aspx
Go to Top of Page
   

- Advertisement -