This workshop is really very helpful. I had no idea that how to read the xml stuff through query but now I am very much clear about it.

Is there any way to directly read from any xml file ?

or

Every time when there is a need to read xml stuff just load all the stuff in particular column then read it.

Any comments regarding my question will be appreciated.

thanks in advance

There is an execellent article by Robyn Page and Phil Factor at http://www.simple-talk.com/sql/t-sql-programming/rss-newsfeed-workbench/

The above article shows how to read a disk file using OPENROWSET + BULK