XML Workshop XVIII - Generating an RSS 2.0 Feed with TSQL

Question

Post reply

XML Workshop XVIII - Generating an RSS 2.0 Feed with TSQL

jacob sebastian

SSChampion

Points: 11822
More actions
April 8, 2008 at 10:22 pm

#123289

Comments posted to this topic are about the item XML Workshop XVIII - Generating an RSS 2.0 Feed with TSQL
.

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

sh10151 Valued Member Points: 52 More actions · Answer 1

I got a challenge. The RSS 2.0 Google Base feed:

http://base.google.com/support/bin/answer.py?answer=58085&hl=en

It seemed like it would be easy using the following:

WITH XMLNAMESPACES (
'urn:http://base.google.com/ns/1.0' as "g"
)

however, the result repeats the namespace for each of the items.

item xmlns:g="urn:http://base.google.com/ns/1.0"

It appears to be well-formed, but I am unsure if Google will accept the feed with the extra namespace for each item. Do you know of another way to do this without the namespace getting repeated?

Anipaul SSC-Insane Points: 24681 More actions · Answer 2

Anipaul

SSC-Insane

Points: 24681

April 9, 2008 at 7:18 am

#800365

Good article. A new area to explore.

🙂

jacob sebastian SSChampion Points: 11822 More actions · Answer 3

I dont think a feed parser will complain for the namespace declaration on the item elements.

I had been writing another article on ATOM feed and realized that feed validators do not complain about the extra namespace declarations on the child elements.

.

sh10151 Valued Member Points: 52 More actions · Answer 4

Thanks Jacob. I will try to upload a feed and see if it they accept it.

Mike DiRenzo SSCrazy Points: 2013 More actions · Answer 5

Fantastic article! This was a good read.

I may use this technique for my one of my websites. I use SQL2k5 and was going to integrate RSS feeds. This technique just gave me the info I was looking for.

-M

Josep SSCommitted Points: 1518 More actions · Answer 6

I've also enjoyed the article.

It's very clean to do that in this way. There's no need to do it in .NET 🙂

I also suppose that it performs much better...

Dan Guzman - Not the MVP Hall of Fame Points: 3757 More actions · Answer 7

I like the article, it's very cool stuff. I'm just starting to look at RSS feeds, and this seems a very simple way to do it, without writing any ASP.net, though it seems if there is a login on your site, you might have too anyway.

My question is:How do I get my web page to see this view?. I run the SELECT statement at the end of your article, and a single item is generated, how do I turn that into a web page people see? I'm missing the final step about how to make this XML public, I guess.

Dan

jacob sebastian SSChampion Points: 11822 More actions · Answer 8

You need to create a page that executes the TSQL code and returns the resultant XML to the HTTP response stream. The caller (usually an rss reader or a browser that understands how to display a feed) will identify the content type and will display the feed accordingly.

.

jacob sebastian SSChampion Points: 11822 More actions · Answer 9

One option is to write a .NET application that executes the query/stored procedure and writes the output to a file: http://www.sqlservercentral.com/articles/XML/62054/

Or use a command line utility like sqlcmd.exe etc that can generate a file with the output of a query.

.