--Объявляем переменные
DECLARE @XML_Doc XML;
DECLARE @XML_Doc_Handle INT;
SET @XML_Doc = (SELECT * FROM OPENROWSET(
BULK 'D:\Документы\SQL Server Management Studio\xmlresult12.xml',
SINGLE_CLOB) AS A)--SINGLE_BLOB
--Подготавливаем XML документ
EXEC sp_xml_preparedocument @XML_Doc_Handle OUTPUT, @XML_Doc;
--Извлекаем данные из XML документа
SELECT N_P AS Id, FAM AS Surname, IM AS Name, OT AS MiddleName, DR AS DateBirth, W AS Gender
FROM OPENXML (@XML_Doc_Handle, '/Z_LIST/ZAP', 2)
WITH (
N_P int,