how to return an XML query as one field

Question

Post reply

how to return an XML query as one field

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 1

You mean like this? Or am I missing something?

DECLARE @X XML

SELECT @X = ( SELECT * FROM sampleTable FOR XML AUTO )

SELECT @X as [@X]

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

zukko SSC Veteran Points: 227 More actions · Answer 2

zukko

SSC Veteran

Points: 227

March 25, 2010 at 12:04 pm

#1139910

yup, that one did the trick! thanks mate.

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 3

Happy to help. 🙂

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills