Sample SQL Server XML from database.
select top 10 * from Database.dbo.vwMyView (NOLOCK)
where SomeXml.value(‘declare namespace s=”http://tempuri.com/schema”; (//s:MyXMLTag)[1]’,’int’) = 2
XML SQL Query
Random outpourings of a software developer
Developer Rants 