{"id":305865,"date":"2020-06-24T15:01:04","date_gmt":"2020-06-24T15:01:04","guid":{"rendered":"http:\/\/savepearlharbor.com\/?p=305865"},"modified":"-0001-11-30T00:00:00","modified_gmt":"-0001-11-29T21:00:00","slug":"","status":"publish","type":"post","link":"https:\/\/savepearlharbor.com\/?p=305865","title":{"rendered":"T-SQL. \u0424\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 XML \u0441\u043e \u0441\u043f\u0438\u0441\u043a\u043e\u043c \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0439"},"content":{"rendered":"\n
<\/p>\n

\u041d\u0435\u0431\u043e\u043b\u044c\u0448\u0430\u044f \u0437\u0430\u043c\u0435\u0442\u043a\u0430 \u043f\u043e \u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044e XML<\/h3>\n

<\/p>\n

FOR XML PATH<\/h3>\n

\u0414\u043b\u044f \u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u044b XML-\u0434\u043e\u043a\u0443\u043c\u0435\u043d\u0442\u0430 \u0441\u043e \u0441\u043f\u0438\u0441\u043a\u043e\u043c \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0439 \u043c\u043e\u0436\u043d\u043e \u0432\u043e\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c\u0441\u044f \u0440\u0435\u0436\u0438\u043c\u043e\u043c PATH \u0434\u043b\u044f FOR XML \u0432 T-SQL.<\/p>\n

<root>     <level1>         <level2><\/level2>         <values>             <value><\/value>             <value><\/value>              <value><\/value>             <value><\/value>             <value><\/value>         <\/values>      <\/level1>      <level1>          <level2><\/level2>          <values>              <value><\/value>              <value><\/value>              <value><\/value>              <value><\/value>              <value><\/value>          <\/values>      <\/level1> <\/root> <\/code><\/pre>\n
<\/a>
  \u041d\u0438\u0436\u0435 \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d sql \u043a\u043e\u0434 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u0442\u0435\u0441\u0442\u043e\u0432\u044b\u0445 \u0442\u0430\u0431\u043b\u0438\u0446 \u0434\u043b\u044f \u0434\u0435\u043c\u043e\u043d\u0441\u0442\u0440\u0430\u0446\u0438\u0438 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432:<\/p>\n
if object_id('dbo.ProductClass', 'U') is not null     drop table dbo.ProductClass; go  create table dbo.ProductClass(     ProductClassId int identity    ,ProductClassName nvarchar(16)    ,constraint PK_ProductClass primary key(ProductClassId)); go  insert into dbo.ProductClass(ProductClassName)     values         ('Class_1')        ,('Class_2')        ,('Class_3'); go  select * from dbo.ProductClass; <\/code><\/pre>\n
  <\/p>\n
1\tClass_1 2\tClass_2 3\tClass_3 <\/code><\/pre>\n
  \u0417\u0430\u043f\u0440\u043e\u0441\u044b \u0431\u0443\u0434\u0443\u0442 \u0437\u0430\u0434\u0435\u0439\u0441\u0442\u0432\u043e\u0432\u0430\u0442\u044c \u0434\u0432\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u044b dbo.ProductClass \u0438 dbo.Product \u0441\u043e \u0441\u0432\u044f\u0437\u044c\u044e \u00ab\u043e\u0434\u0438\u043d \u043a\u043e \u043c\u043d\u043e\u0433\u0438\u043c\u00bb(\u0432 \u043e\u0434\u043d\u043e\u043c \u043a\u043b\u0430\u0441\u0441\u0435 \u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0442\u044c \u0431\u043e\u043b\u0435\u0435 \u043e\u0434\u043d\u043e\u0433\u043e \u043f\u0440\u043e\u0434\u0443\u043a\u0442\u0430).<\/p>\n
if object_id('dbo.Product', 'U') is not null     drop table dbo.Product; go  create table dbo.Product(     ProductClassId int     ,ProductId int identity     ,ProductName nvarchar(16)     ,constraint PK_Product primary key(ProductId)     ,constraint FK_ProductClass foreign key(ProductClassId)         references dbo.ProductClass(ProductClassId)); go  insert into dbo.Product(ProductClassId, ProductName)     values         (1, 'Product_1')         ,(2, 'Product_2')         ,(3, 'Product_3')         ,(1, 'Product_4')         ,(2, 'Product_5')         ,(3, 'Product_6')         ,(1, 'Product_7')         ,(3, 'Product_8')         ,(2, 'Product_9')         ,(1, 'Product_10'); go  select * from dbo.Product; <\/code><\/pre>\n
  <\/p>\n
1\t1\tProduct_1 2\t2\tProduct_2 3\t3\tProduct_3 1\t4\tProduct_4 2\t5\tProduct_5 3\t6\tProduct_6 1\t7\tProduct_7 3\t8\tProduct_8 2\t9\tProduct_9 1\t10\tProduct_10 <\/code><\/pre>\n
  \u0421\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0439 \u0437\u0430\u043f\u0440\u043e\u0441 \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u043f\u043e\u0441\u0442\u0440\u043e\u0438\u0442\u044c XML \u0434\u043e\u043a\u0443\u043c\u0435\u043d\u0442 \u0441\u043e \u0441\u043f\u0438\u0441\u043a\u043e\u043c \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0439 ProductName \u0442\u0430\u0431\u043b\u0438\u0446\u044b dbo.Product \u0434\u043b\u044f \u043a\u0430\u0436\u0434\u043e\u0433\u043e \u043a\u043b\u0430\u0441\u0441\u0430 \u043f\u0440\u043e\u0434\u0443\u043a\u0442\u0430(ProductClassName) \u0432 \u043e\u0434\u043d\u043e\u0438\u043c\u0435\u043d\u043d\u044b\u0445 \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u0430\u0445:<\/p>\n
select pc.ProductClassName as ProductClassName     ,(select p.ProductName as ProductName         from dbo.Product p     where p.ProductClassId = pc.ProductClassId         for xml path(''), type) as "Products" from dbo.ProductClass pc     for xml path('ProductClass'), type <\/code><\/pre>\n
  \u0421\u043f\u0438\u0441\u043e\u043a \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0439 \u0432 \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u0435 Products \u0444\u043e\u0440\u043c\u0438\u0440\u0443\u0435\u0442\u0441\u044f \u043f\u043e\u0434\u0437\u0430\u043f\u0440\u043e\u0441\u043e\u043c: <\/p>\n
(select p.ProductName as ProductName     from dbo.Product p where p.ProductClassId = pc.ProductClassId     for xml path(''), type) as "Products") <\/code><\/pre>\n
  \u041f\u0441\u0435\u0432\u0434\u043e\u043d\u0438\u043c\u044b \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u044f\u044e\u0442 \u00ab\u0438\u043c\u0435\u043d\u0430\u00bb XML \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u043e\u0432. \u0414\u0438\u0440\u0435\u043a\u0442\u0438\u0432\u0430 TYPE \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u043f\u043e\u043b\u0443\u0447\u0438\u0442\u044c \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442 \u0437\u0430\u043f\u0440\u043e\u0441\u0430 \u0432 \u0432\u0438\u0434\u0435 \u0442\u0438\u043f\u0430 \u0434\u0430\u043d\u043d\u044b\u0445 xml. \u0414\u043b\u044f \u0442\u043e\u0433\u043e \u0447\u0442\u043e \u0431\u044b \u043d\u0435 \u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043b\u0441\u044f \u0440\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u0441\u043a\u0438\u0439 \u044d\u043b\u0435\u043c\u0435\u043d\u0442 \u0434\u043b\u044f \u0441\u043f\u0438\u0441\u043a\u0430 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0439 \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u043e\u0432 Product.ProductName, \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 PATH \u043d\u0435 \u0443\u043a\u0430\u0437\u044b\u0432\u0430\u0435\u0442\u0441\u044f(for xml path(»)).<\/p>\n
  \u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u043e\u043c \u0437\u0430\u043f\u0440\u043e\u0441\u0430 \u0431\u0443\u0434\u0435\u0442 \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0439 XML-\u0434\u043e\u043a\u0443\u043c\u0435\u043d\u0442:<\/p>\n
<ProductClass>     <ProductClassName>Class_1<\/ProductClassName>     <Products>         <ProductName>Product_1<\/ProductName>         <ProductName>Product_4<\/ProductName>         <ProductName>Product_7<\/ProductName>         <ProductName>Product_10<\/ProductName>     <\/Products> <\/ProductClass> <ProductClass>     <ProductClassName>Class_2<\/ProductClassName>     <Products>         <ProductName>Product_2<\/ProductName>         <ProductName>Product_5<\/ProductName>         <ProductName>Product_9<\/ProductName>     <\/Products> <\/ProductClass> <ProductClass>     <ProductClassName>Class_3<\/ProductClassName>     <Products>         <ProductName>Product_3<\/ProductName>         <ProductName>Product_6<\/ProductName>         <ProductName>Product_8<\/ProductName>     <\/Products> <\/ProductClass> <\/code><\/pre>\n
  \u0414\u043b\u044f \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u0441\u043f\u0438\u0441\u043a\u0430 \u0441\u043e \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f\u043c\u0438 \u0432 \u0430\u0442\u0440\u0438\u0431\u0443\u0442\u0430\u0445 \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u0430, \u043f\u0441\u0435\u0432\u0434\u043e\u043d\u0438\u043c\u044b \u0443\u043a\u0430\u0437\u044b\u0432\u0430\u044e\u0442\u0441\u044f \u0432 \u043a\u0430\u0432\u044b\u0447\u043a\u0430\u0445(\u043e\u0434\u0438\u043d\u0430\u0440\u043d\u044b\u0435 \u0438\u043b\u0438 \u0434\u0432\u043e\u0439\u043d\u044b\u0435) \u0441 \u0441\u0438\u043c\u0432\u043e\u043b\u043e\u043c ‘@’ \u0432 \u043d\u0430\u0447\u0430\u043b\u0435:<\/p>\n
select pc.ProductClassName as ProductClassName     ,(select p.ProductId as "@ProductId", p.ProductName as '@ProductName'         from dbo.Product p     where p.ProductClassId = pc.ProductClassId         for xml path('Product'), type) as "Products" from dbo.ProductClass pc     for xml path('ProductClass'), type <\/code><\/pre>\n
  \u0417\u043d\u0430\u0447\u0435\u043d\u0438\u0435 PATH \u0435\u0441\u0442\u044c \u00ab\u0438\u043c\u044f\u00bb \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u0430 \u0432 \u043a\u043e\u0442\u043e\u0440\u043e\u043c \u0441\u043e\u0434\u0435\u0440\u0436\u0430\u0442\u044c\u0441\u044f \u0430\u0442\u0440\u0438\u0431\u0443\u0442\u044b, \u0440\u0435\u0437\u0443\u043b\u044c\u0442 \u0437\u0430\u043f\u0440\u043e\u0441\u0430 \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0439:<\/p>\n
<ProductClass>     <ProductClassName>Class_1<\/ProductClassName>     <Products>         <Product ProductId="1" ProductName="Product_1" \/>         <Product ProductId="4" ProductName="Product_4" \/>         <Product ProductId="7" ProductName="Product_7" \/>         <Product ProductId="10" ProductName="Product_10" \/>     <\/Products> <\/ProductClass> <ProductClass>     <ProductClassName>Class_2<\/ProductClassName>     <Products>         <Product ProductId="2" ProductName="Product_2" \/>         <Product ProductId="5" ProductName="Product_5" \/>         <Product ProductId="9" ProductName="Product_9" \/>     <\/Products> <\/ProductClass> <ProductClass>     <ProductClassName>Class_3<\/ProductClassName>     <Products>         <Product ProductId="3" ProductName="Product_3" \/>         <Product ProductId="6" ProductName="Product_6" \/>         <Product ProductId="8" ProductName="Product_8" \/>     <\/Products> <\/ProductClass> <\/code><\/pre>\n
  \u0410\u0442\u0440\u0438\u0431\u0443\u0442\u044b \u043c\u043e\u0436\u043d\u043e \u0440\u0430\u0437\u043c\u0435\u0441\u0442\u0438\u0442\u044c \u0432 \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u044b\u0445 \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u0430\u0445:<\/p>\n
select pc.ProductClassName as ProductClassName     ,(select p.ProductId as "@ProductId", p.ProductName as ProductName         from dbo.Product p     where p.ProductClassId = pc.ProductClassId         for xml path('Product'), type) as "Products" from dbo.ProductClass pc     for xml path('ProductClass'), type <\/code><\/pre>\n
  \u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442 \u0437\u0430\u043f\u0440\u043e\u0441\u0430:<\/p>\n
<ProductClass>   <ProductClassName>Class_1<\/ProductClassName>   <Products>     <Product ProductId="1">       <ProductName>Product_1<\/ProductName>     <\/Product>     <Product ProductId="4">       <ProductName>Product_4<\/ProductName>     <\/Product>     <Product ProductId="7">       <ProductName>Product_7<\/ProductName>     <\/Product>     <Product ProductId="10">       <ProductName>Product_10<\/ProductName>     <\/Product>   <\/Products> <\/ProductClass> <ProductClass>   <ProductClassName>Class_2<\/ProductClassName>   <Products>     <Product ProductId="2">       <ProductName>Product_2<\/ProductName>     <\/Product>     <Product ProductId="5">       <ProductName>Product_5<\/ProductName>     <\/Product>     <Product ProductId="9">       <ProductName>Product_9<\/ProductName>     <\/Product>   <\/Products> <\/ProductClass> <ProductClass>   <ProductClassName>Class_3<\/ProductClassName>   <Products>     <Product ProductId="3">       <ProductName>Product_3<\/ProductName>     <\/Product>     <Product ProductId="6">       <ProductName>Product_6<\/ProductName>     <\/Product>     <Product ProductId="8">       <ProductName>Product_8<\/ProductName>     <\/Product>   <\/Products> <\/ProductClass> <\/code><\/pre>\n
  Product.ProductName \u043a\u0430\u043a \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u0430 Product \u0438 Product.ProductId \u043a\u0430\u043a \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 \u0430\u0442\u0440\u0438\u0431\u0443\u0442\u0430 \u044d\u0442\u043e\u0433\u043e \u0436\u0435 \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u0430:<\/p>\n
select pc.ProductClassName as ProductClassName     ,(select p.ProductId as "@ProductId" \t,(select pn.ProductName  \t\tfrom dbo.Product pn \twhere pn.ProductId = p.ProductId)         from dbo.Product p     where p.ProductClassId = pc.ProductClassId         for xml path('Product'), type) as "Products" from dbo.ProductClass pc     for xml path('ProductClass'), type <\/code><\/pre>\n
  \u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442:<\/p>\n
<ProductClass>   <ProductClassName>Class_1<\/ProductClassName>   <Products>     <Product ProductId="1">Product_1<\/Product>     <Product ProductId="4">Product_4<\/Product>     <Product ProductId="7">Product_7<\/Product>     <Product ProductId="10">Product_10<\/Product>   <\/Products> <\/ProductClass> <ProductClass>   <ProductClassName>Class_2<\/ProductClassName>   <Products>     <Product ProductId="2">Product_2<\/Product>     <Product ProductId="5">Product_5<\/Product>     <Product ProductId="9">Product_9<\/Product>   <\/Products> <\/ProductClass> <ProductClass>   <ProductClassName>Class_3<\/ProductClassName>   <Products>     <Product ProductId="3">Product_3<\/Product>     <Product ProductId="6">Product_6<\/Product>     <Product ProductId="8">Product_8<\/Product>   <\/Products> <\/ProductClass> <\/code><\/pre>\n
  \u0418\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435 \u043a\u043e\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u0438 WITH XMLNAMESPACES \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0434\u043e\u0431\u0430\u0432\u0438\u0442\u044c \u043f\u0440\u043e\u0441\u0442\u0440\u0430\u043d\u0441\u0442\u0432\u0430 \u0438\u043c\u0435\u043d \u0432 XML:<\/p>\n
WITH XMLNAMESPACES ('uri1' as lev)   select pc.ProductClassName as "lev:ProductClassName"     ,(select p.ProductName as "lev:ProductName"         from dbo.Product p     where p.ProductClassId = pc.ProductClassId         for xml path(''), type) as "lev:Products" from dbo.ProductClass pc     for xml path('lev:ProductClass'), type <\/code><\/pre>\n
  <\/p>\n
<lev:ProductClass xmlns:lev="uri1">   <lev:ProductClassName>Class_1<\/lev:ProductClassName>   <lev:Products>     <lev:ProductName xmlns:lev="uri1">Product_1<\/lev:ProductName>     <lev:ProductName xmlns:lev="uri1">Product_4<\/lev:ProductName>     <lev:ProductName xmlns:lev="uri1">Product_7<\/lev:ProductName>     <lev:ProductName xmlns:lev="uri1">Product_10<\/lev:ProductName>   <\/lev:Products> <\/lev:ProductClass> <lev:ProductClass xmlns:lev="uri1">   <lev:ProductClassName>Class_2<\/lev:ProductClassName>   <lev:Products>     <lev:ProductName xmlns:lev="uri1">Product_2<\/lev:ProductName>     <lev:ProductName xmlns:lev="uri1">Product_5<\/lev:ProductName>     <lev:ProductName xmlns:lev="uri1">Product_9<\/lev:ProductName>   <\/lev:Products> <\/lev:ProductClass> <lev:ProductClass xmlns:lev="uri1">   <lev:ProductClassName>Class_3<\/lev:ProductClassName>   <lev:Products>     <lev:ProductName xmlns:lev="uri1">Product_3<\/lev:ProductName>     <lev:ProductName xmlns:lev="uri1">Product_6<\/lev:ProductName>     <lev:ProductName xmlns:lev="uri1">Product_8<\/lev:ProductName>   <\/lev:Products> <\/lev:ProductClass> <\/code><\/pre>\n
  \u041a\u043e\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u044f data() \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0441\u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u0441\u043f\u0438\u0441\u043e\u043a \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0439, \u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440 \u0442\u0440\u0435\u0431\u0443\u0435\u0442\u0441\u044f \u043f\u0435\u0440\u0435\u0447\u0438\u0441\u043b\u0438\u0442\u044c \u0432\u0441\u0435 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f ProductId \u0434\u043b\u044f \u043a\u0430\u0436\u0434\u043e\u0433\u043e \u043a\u043b\u0430\u0441\u0441\u0430 \u043f\u0440\u043e\u0434\u0443\u043a\u0442\u0430 \u0432 \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u0435 ProductClass:<\/p>\n
select pc.ProductClassName as "@ProductClassName"     ,(select pid.ProductId as "data()"         from dbo.Product pid     where pid.ProductClassId = pc.ProductClassId         for xml path ('')) as "@ProductIds"     ,(select p.ProductId as "@ProductId", p.ProductName as '@ProductName'         from dbo.Product p     where p.ProductClassId = pc.ProductClassId         for xml path('Product'), type) as "Products" from dbo.ProductClass pc     for xml path('ProductClass'), type <\/code><\/pre>\n
  <\/p>\n
<ProductClass ProductClassName="Class_1" ProductIds="1 4 7 10">   <Products>     <Product ProductId="1" ProductName="Product_1" \/>     <Product ProductId="4" ProductName="Product_4" \/>     <Product ProductId="7" ProductName="Product_7" \/>     <Product ProductId="10" ProductName="Product_10" \/>   <\/Products> <\/ProductClass> <ProductClass ProductClassName="Class_2" ProductIds="2 5 9">   <Products>     <Product ProductId="2" ProductName="Product_2" \/>     <Product ProductId="5" ProductName="Product_5" \/>     <Product ProductId="9" ProductName="Product_9" \/>   <\/Products> <\/ProductClass> <ProductClass ProductClassName="Class_3" ProductIds="3 6 8">   <Products>     <Product ProductId="3" ProductName="Product_3" \/>     <Product ProductId="6" ProductName="Product_6" \/>     <Product ProductId="8" ProductName="Product_8" \/>   <\/Products> <\/ProductClass> <\/code><\/pre>\n
  \u0411\u043e\u043b\u044c\u0448\u0435 \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u0438<\/a><\/div>\n
 \u0441\u0441\u044b\u043b\u043a\u0430 \u043d\u0430 \u043e\u0440\u0438\u0433\u0438\u043d\u0430\u043b \u0441\u0442\u0430\u0442\u044c\u0438  https:\/\/habr.com\/ru\/post\/506942\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"\n
<\/p>\n
\u041d\u0435\u0431\u043e\u043b\u044c\u0448\u0430\u044f \u0437\u0430\u043c\u0435\u0442\u043a\u0430 \u043f\u043e \u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044e XML<\/h3>\n
  <\/p>\n
FOR XML PATH<\/h3>\n
  \u0414\u043b\u044f \u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u044b XML-\u0434\u043e\u043a\u0443\u043c\u0435\u043d\u0442\u0430 \u0441\u043e \u0441\u043f\u0438\u0441\u043a\u043e\u043c \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0439 \u043c\u043e\u0436\u043d\u043e \u0432\u043e\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c\u0441\u044f \u0440\u0435\u0436\u0438\u043c\u043e\u043c PATH \u0434\u043b\u044f FOR XML \u0432 T-SQL.<\/p>\n
<root>     <level1>         <level2><\/level2>         <values>             <value><\/value>             <value><\/value>              <value><\/value>             <value><\/value>             <value><\/value>         <\/values>      <\/level1>      <level1>          <level2><\/level2>          <values>              <value><\/value>              <value><\/value>              <value><\/value>              <value><\/value>              <value><\/value>          <\/values>      <\/level1> <\/root> <\/code><\/pre>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-305865","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/posts\/305865","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=305865"}],"version-history":[{"count":0,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/posts\/305865\/revisions"}],"wp:attachment":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=305865"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=305865"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=305865"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}