Hi Shaw, Thanks for your reply. I Searched the all drives, but dont find missing ndf file. But i have the backup file which is very old. using this backup...
working fine. I read SQL Books online to understand what is this CROSS/OUTER APPLY. What i understood from the books online is CROSS/OUTER APPLY are used for "to iterate...
this is good as long as the XML is untyped. What if the XML is in a XML DB Column ? for example AdventureWorks DB's HumarResuource.JobCandidate.Resume column ??