SQL Server has a handy option for loading XML data directly from the file system, the OPENROWSET function. To load XML files into SQL Server, simply declare an xml data type variable and assign it the value of the OPENROWSET function with the BULK option. Here's a quick example that uses the state...