TSQL: importing XML data using OPENROWSET

CREATE TABLE xml_documents( x XML );

 INSERT INTO xml_documents ( x )

   SELECT * FROM OPENROWSET(BULK N’myXmlFile.xml’, SINGLE_BLOB) AS x;

GO

TSQL: DELETE FROM Joined Table

DELETE TableA 
FROM TableA AS a
INNER JOIN TableB AS b
ON a.BId = b.BId
WHERE [filter condition]