Solved

Generating XML file in  SQL Server 2005

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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
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.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

757 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now