Can you free-text search an XML file using SQL Server?

I have an X开发者_如何学编程ML feed of a resume. Each part of the resume is broken down into its constituent parts. For example <employment_history>, <education>, <skills>.

I am aware that I could save each section of the XML file into a database. For example columnID = employment_history | education | skills & then conduct a free text search just on those individual columns. However I would prefer not to do this because it would create duplication of data that is already contained within the XML file and may put extra strain on indexing.

Therefore I wondered if it is possible to conduct a free text search of an XML file within the <employment_history></employment_history> using SQL Server.

If so an example would be appreciated.

Are you aware that SQL Server supports columns with the data type of "XML"? These can contain an entire XML document.

You can also index these columns and you can use XQuery to perform query and data manipulation tasks on those columns.

See Designing and Implementing Semistructured Storage (Database Engine)

Querying xml by doing string searching using sql is probably going to run into a lot of trouble.

Instead, I would parse it into whatever language you're using to interact with your database and use xpath (most languages/environments have some kind of built in or popular 3rd party library) to query it.

I think you can create a function (UDF) that takes the xml text as a parameter then it fetches the data inside tag then you make the filter you want