MS SQL XML - How can I concatenate fields XML in Yukon?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

How can I concatenate fields XML in Yukon?

sqlextreme

2006-11-21, 7:16 pm

for example:

XML 1: <CAR name="1">

XML 2: <CAR name="2">

XML expected:
<CAR name="1">
<CAR name="2">

Thank.

Kent Tegels

2006-11-21, 7:16 pm

Hello sqlextreme,

declare @x1 xml,@x2 xml
set @x1 = '<CAR name="1"/>'
set @x2 = '<CAR name="2"/>'
set @x1 = cast(cast(@x1 as varbinary(max))+cast
(@x2 as varbinary(max)) as
xml)
select @x1

Thanks,
Kent Tegels
http://staff.develop.com/ktegels/

sqlextreme

2006-11-22, 7:16 pm

thank you for your Help, Kent Tegels

Sponsored Links