Hi
I have a quick question. I'm studying how XML works in sq server 2005, and I've hit the following code online that I can't completely understand (see below code).
I know what it does, how it works, but it's just the part "AS feed (xmlData)" that I'm trying to fully understand. I get the 'As feed' is an alias,but why must the (xmlData) be there?
If anyone can answer this (i'm asuuming simple question!) I would greatly appreciate it.
Thanks.
INSERT INTO rssFeeds (feedName, feedXML)
SELECT 'MSDNRSS', xmlData FROM
(
SELECT * FROM OPENROWSET
(BULK 'C:\Temp\rss.xm l', SINGLE_CLOB)
AS xmlData
) AS feed (xmlData)
GO