sql-server - 在 T-SQL 中连接 XML 片段

Question

我有这个代码

select * from #ENTETE
for xml path ('ENTETE')

select * from #DECLARATION
for xml path ('DECLARATION')


select * from #CARACTERISTIQUE_TITRE
for xml path ('CARATERISTIQUE_TITRE') 

select * from #MOUVEMENT_TITRE
for xml path ('MOUVEMENT_TITRE') 


select * from #ENCOURS
for xml path ('ENCOURS') 

我有这个结果

但我想得到这个结果

结果我希望

标签： sql-serverxmltsql

Answer 1

select '20190302' as date_declaration, 'abc' as Type_Fischier, 1 AS numero_de_remise
into #ENTETE;

select '' as cib_emetteur into #DECLARATION;

select 'c' as type_mouvement, 11111 as type_tcn, 'fr12345' as code_isin
into #CARATERISTIQUE_TITRE;
go

select
(
select *
from #ENTETE
for xml path('ENTETE'), type
), 
(
select *
from #DECLARATION
for xml path('DECLARATION'), type
),
(
select *
from #CARATERISTIQUE_TITRE
for xml path('CARATERISTIQUE_TITRE'), type
)
for xml path(''), type;

declare @result xml = (
select
(
select *
from #ENTETE
for xml path('ENTETE'), type
), 
(
select *
from #DECLARATION
for xml path('DECLARATION'), type
),
(
select *
from #CARATERISTIQUE_TITRE
for xml path('CARATERISTIQUE_TITRE'), type
)
for xml path(''), type
);

select @result;
go