Solved

Generating XML file in  SQL Server 2005

Posted on 2008-06-23
2
355 Views
Last Modified: 2012-06-27
I have a SQL table  JOB_REGISTRATION with columns
I want to generate the xml file with the following headers and content in the format specified

<?xml version="1.0" encoding="UTF-8"?><urlset    xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.sitemaps.org/schemas/sitemap/0.9  http://www.sitemaps.org/schemas/sitemap/0.9/sitemap.xsd">          
<url>
<loc>replace this space with the content from the sql table column ( COLUMN NAME IS JOB_TITLE)</loc>
<priority>0.5</priority>
<changefreq>daily</changefreq>
</url>
How do i generate the list using sql server.
0
Comment
Question by:TECH_NET
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 14

Assisted Solution

by:Jagdish Devaku
Jagdish Devaku earned 20 total points
ID: 21852825
hi,

please refer to the following link which might help you...

http://www.simple-talk.com/sql/sql-server-2005/beginning-sql-server-2005-xml-programming/

all the best...
0
 

Accepted Solution

by:
TECH_NET earned 0 total points
ID: 22355638
The solutions offered does not meet my requirements. Please close the question
0

Featured Post

The Ultimate Checklist to Optimize Your Website

Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question