Get XML into TSQL variable

Question

Post reply

Get XML into TSQL variable

Mister Ken

SSChasing Mays

Points: 659
More actions
May 12, 2010 at 3:32 pm

#73678

I created a SELECT statement with a "FOR PATH" to get XML output.
How could I capture the XML into a TSQL variable ?

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

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

WayneS SSC Guru Points: 95460 More actions · Answer 1

set @YourVar = ((select ... FOR XML))

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Mister Ken SSChasing Mays Points: 659 More actions · Answer 2

Mister Ken

SSChasing Mays

Points: 659

May 12, 2010 at 5:22 pm

#1166579

Thanks!