XML RELATED OPENROWSET - SQL Server Forums

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)

XML RELATED OPENROWSET

Author

Topic

parvathaneni.vk
Starting Member

3 Posts

Posted - 2008-06-20 : 01:46:41

select @xml = bulkcolumn from openrowset(bulk 'C:\Documents and
Settings\Kasi\Desktop\newsrss.xml' , single_blob) as channel

here after bulk instead of giving path, we have to give parameter so that the paramter takes the value from the table.

the tables contains paths of xml files

chetanb3
Yak Posting Veteran

52 Posts

Posted - 2008-06-20 : 02:18:43

Do u want to select from xml column ..?
what is content of this column is it file path ?

parvathaneni.vk
Starting Member

3 Posts

Posted - 2008-06-20 : 04:21:31

the content in the file path is xml data

<?xml version="1.0" encoding="ISO-8859-1"?>
<rss version="0.91">
<channel>
<title>rediff News: International</title>
<link>http://www.rediff.com/news/index.html</link>
<description>India's largest news and entertainment service online.</description>
<language>en-us</language>
<pubDate>Fri, 20 Jun 2008 07:30:16 GMT</pubDate>
<copyright>Copyright: (C) 2008 Rediff.com India Limited. All Rights Reserved.</copyright>
<image>
<title>rediff.com</title>
<url>http://www.rediff.com/uim/red_log.gif</url>
<link>http://www.rediff.com/</link>
<width>144</width>
<height>28</height>
<description>Visit rediff.com</description>
</image>


<item>
<title>269,000 people died to liberate B'desh: Study</title>
<link>http://www.rediff.com/rss/redirect.php?url=http://www.rediff.com/news/2008/jun/20bangla.htm</link>
<description>The study, titled 'Fifty years of violent war deaths from Vietnam to Bosnia: analysis of data from the world health survey programme', published in the British Medical Journal said: 'War causes more deaths than previously estimated, and there is no evidence to support a recent decline in war deaths'. </description>
</item>

<item>
<title>Ramadoss will attend say AAPI leaders</title>
<link>http://www.rediff.com/rss/redirect.php?url=http://www.rediff.com/news/2008/jun/19us.htm</link>
<description>On tap to keynote the 26th annual Convention of the American Association of Physicians of Indian Origin—arguably the largest and most influential ethnic professional organization in the United States—in Las Vegas next week, is Indian Health Minister Dr Anbumani Ramadoss, who AAPI leaders say has confirmed he will attend despite rumors to the contrary because of Prime Minister Manmohan Singh's austerity drive discouraging his ministers from foreign travel.</description>
</item>

<item>
<title>Radical bishops split Anglican church</title>
<link>http://www.rediff.com/rss/redirect.php?url=http://www.rediff.com/news/2008/jun/19split.htm</link>
<description>A religious row has erupted among Christian leaders, with conservative priests moving to split the worldwide Anglican Communion over liberal attitude towards homosexuals.</description>
</item>

<item>
<title>Sri Lanka says it's ready to talk to LTTE</title>
<link>http://www.rediff.com/rss/redirect.php?url=http://www.rediff.com/news/2008/jun/19lanka.htm</link>
<description>Sri Lanka has offered to hold talks with the Liberation Tigers of Tamil Eelam after a two-year gap, saying the outfit does represent a fair amount of Tamils but ruled out the immediate revival of the ceasefire scrapped in January.</description>
</item>

<item>
<title>Where are American nuclear missile parts?</title>
<link>http://www.rediff.com/rss/redirect.php?url=http://www.rediff.com/news/2008/jun/19nuke.htm</link>
<description>The Pentagon has been unable to locate hundreds of sensitive nuclear missile components in the United States inventory, according to top officials familiar with a highly confidential report by the American defence department.The finding comes after the air force last year found that a bomber mistakenly flew across the US with six nuclear warheads onboard.Washington recently dismissed its top air force officials, including the Chief of Staff and Service.</description>
</item>

<item>
<title>Pak: Open 'courts' to hear women's grievances </title>
<link>http://www.rediff.com/rss/redirect.php?url=http://www.rediff.com/news/2008/jun/19pak1.htm</link>
<description>The organisation headed by Mukhtar Mai, who was an anonymous Pakistani villager till she was gang-raped on the orders of a tribal council in February 2002, will assist victimised women with financial and legal aid.</description>
</item>

<item>
<title>Gene therapy used to treat cancer for first time</title>
<link>http://www.rediff.com/rss/redirect.php?url=http://www.rediff.com/news/2008/jun/19cancer.htm</link>
<description>In the first case of its kind, doctors have treated a cancer patient by injecting him with billions of his own immune cells, a development that projects the huge power of gene therapy for the killer disease.</description>
</item>

<item>
<title>Pakistan: Seven killed in Shia-Sunni clashes</title>
<link>http://www.rediff.com/rss/redirect.php?url=http://www.rediff.com/news/2008/jun/19pak.htm</link>
<description>Seven persons were killed and over 10 injured in sectarian clashes in Pakistan's northwestern Kurram tribal area, where skirmishes between Shias and Sunnis continued for the second day on Thursday.</description>
</item>

<item>
<title>US needs a tougher policy on Pakistan: Obama</title>
<link>http://www.rediff.com/rss/redirect.php?url=http://www.rediff.com/news/2008/jun/19uspoll.htm</link>
<description>Presumptive Democratic nominee Barack Obama has said that the United States should finish the fight against terror outfits Al Qaida and Taliban instead of sending troops to Iraq."We should finish the fight against Al Qaida and Taliban instead of going into Iraq. We need to take more resources and put them in Afghan - at least two additional combat brigades and US$ 1 billion in non-military assistance each year," Obama said. </description>
</item>

<item>
<title>Sikh girl battles UK school over <I>Kara</I></title>
<link>http://www.rediff.com/rss/redirect.php?url=http://www.rediff.com/news/2008/jun/18sikh.htm</link>
<description>A Sikh schoolgirl who was forbidden from attending classes after she refused to remove her Kara told a British Court that she should not have been asked to take it off because it was a symbol of faith and not a piece of jewellery.</description>
</item>
</channel>
</rss>

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources