CROSS APPLY是您找不到的东西…
select yourtable.*from yourtable cross apply yourtable.RecordFields.nodes('/Record/RecordField') as tx(r)where tx.r.value('.','varchar(10)') like '%'+@searchterm+'%'或者
where tx.r.value('contains((.),sql:variable("@searchterm"))','bit')=1
