producing an rss feed

No apologies for being rather late to this party, just treat me kindly please.

Short question: How do you create an RSS feed?

Long question: Do you create an RSS feed with a query from the database in a fully formed (XML) fashion or use an application of some sort to take the data and wrap it in tags etc.?

Either way, I have a database and a website and want to make an RSS feed for it and look forward to your suggestions/ideas.

more ▼

asked Jul 19, 2010 at 07:29 AM in Default

avatar image

Fatherjack ♦♦
43.8k 79 101 118

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Jacob Sebastian touched on RSS Feed generation in an [article at SSC][1].

He made fully formed XML following the RSS 2.0 specs. I am not too sure what the steps would be after that though, spit it out using SSIS/bcp or some sort of homebrew exporter.

Not mind-blowing, but it is a start :o) [1]: http://www.sqlservercentral.com/articles/XML/62661/

more ▼

answered Jul 19, 2010 at 07:35 AM

avatar image

26.2k 18 37 48

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jul 19, 2010 at 07:29 AM

Seen: 1386 times

Last Updated: Jul 19, 2010 at 07:33 AM

Copyright 2018 Redgate Software. Privacy Policy