Solved

Generating XML file in  SQL Server 2005

Posted on 2008-06-23
2
352 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
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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Change variables in SQL table 6 87
SSRS report parameters set after publishing to report manager 1 56
Set the max value for a column 7 38
Strange msg in the SSMS pane 13 56
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

777 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