CREATE TABLE #temp (
dt DATETIME,
col1 XML
)

/*Use the OPENROWSET AND BULK load to load an xml File into
the table. GETDATE() is used to populate the first column*/
Insert #temp
SELECT GETDATE(), *
FROM OPENROWSET(BULK 'C:\Employees.xsd',
SINGLE_BLOB) AS x;

SELECT *
FROM #temp