SQLTeam.com | Weblogs | Forums

T-SQL from XML file

Is it possible to use T-SQL to query an XML file, without using SSIS?

I have an XML file that contains data that is linked to the database. I need to treat that XML file like a table. The XML file changes fairly frequently.