Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Tim
Starting Member
392 Posts |
 Posted - 2003-10-24 : 09:45:46
|
| Can anyone show me an easy way to pump the weblogs feed from [url]http://weblogs.sqlteam.com/MainFeed.aspx[/url] into a set of tables in SQL Server? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-10-24 : 18:45:42
|
| You would have to determine a structure for the table(s) you want to insert this data into, but the OPENXML function should be able to help you out. You'll have to read up on it in Books Online, I'm not well-versed in its function. You might find some other methods here:http://msdn.microsoft.com/library/default.asp?url=/nhp/Default.asp?contentid=28001300You can also use the MSXML COM objects to open the RSS feed and parse it, but it would require VB/C++ code to do it (don't try to do this in T-SQL using sp_OA methods, it will get very ugly) MSDN has examples:http://msdn.microsoft.com/nhp/default.asp?contentid=28000438 |
 |
|
|
|
|
|
RSS > SQL Server Tables?