vignesh.ms (4/18/2014)
also explain how does above query works ???
SQL Server Books Online is your best friend. If you don't have a local copy, download it from Microsoft.
Click Index and search XML [SQL Server]. If you have questions on the BOL material, post them here and we'll do our best to answer them.