question

Fatherjack avatar image
Fatherjack asked

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.
tsqlrss
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
WilliamD avatar image
WilliamD answered
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/
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.