Options
SQL 2012 - XML Question
garywin7
Member Posts: 21 ■□□□□□□□□□
Hi
I may be remembering this wrong but
is there a way of outputting :-
<Name>Fred/Bloggs<Name>
so combining 2 columns into one element ?
if this is nonsense then just let me know , no need to swear though . . .
I may be remembering this wrong but
is there a way of outputting :-
<Name>Fred/Bloggs<Name>
so combining 2 columns into one element ?
if this is nonsense then just let me know , no need to swear though . . .
Comments
-
OptionsNotHackingYou
Member Posts: 1,460 ■■■■■■■■□□
If the columns are non XML columns then you can use simple concatenation. SELECT '<name>' + firstName + '/' + lastName + '</name>' FROM usersTable WHERE (conditions). This will output in the format you want. There are other ways to do this but this is quick.
If you are trying to extract from an XML column then it is a little tricker.When you go the extra mile, there's no traffic. -
Optionsgarywin7
Member Posts: 21 ■□□□□□□□□□
Hi
I'm thinking of non-xml columns so I know you can use FOR XML AUTO etc.
and its that type of answer i'm really looking for
good idea on the select string approach though