SQL XML Insert attribute to node

Question

I need to add an attribute tag='plan' to the column tisa_LayoutURL with the node Image. See my query below

select @xml = 
    (
            SELECT art.tisa_Code AS [@internal-id],
                cla.tisa_image1 AS [image], '',
                cla.tisa_image2 AS [image], '',
                cla.tisa_image3 AS [image], '',
                cla.tisa_image4 AS [image], '',
                art.tisa_LayoutUrl AS [image],
                addr.tisa_Description AS [description]
    FROM tisa_article art JOIN 
         tisa_Address addr ON addr.tisa_AddressId = art.tisa_AddressId JOIN
         tisa_Classifier cla ON cla.tisa_classifierid = addr.tisa_classifierid 
    JOIN
         Account Acc ON Acc.AccountId=cla.tisa_vendorid
    FOR XML PATH('offer'), root('realty-feed'))

I need to obtain the following:

<image>xxxxx.jpg</image>
<image>xxxx1.jpg</image>
<image>xxxx2.jpg</image>
<image>xxxx3.jpg</image>
<image tag="plan">xxxx4.jpg</image>

how can i modify my query to achieve that?

I'm assuming you are working in a SQL Server database?

TT.
– TT.

2017-08-21 14:30:43 +00:00
Commented Aug 21, 2017 at 14:30 — TT.
– TT., Commented Aug 21, 2017 at 14:30

TT. · Accepted Answer · 2017-08-21 14:28:16Z

1

Replace the line

art.tisa_LayoutUrl AS [image],

with:

'plan' AS "image/@tag",
art.tisa_LayoutUrl AS [image],

answered Aug 21, 2017 at 14:28

TT.

16.2k6 gold badges53 silver badges95 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Oscar Dominguez Navarrete Over a year ago

Thank you! It helped me!

Collectives™ on Stack Overflow

SQL XML Insert attribute to node

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related