Row as XML in SP

Posted by user171523 on Stack Overflow See other posts from Stack Overflow or by user171523
Published on 2010-03-29T18:13:10Z Indexed on 2010/03/29 18:33 UTC
Read the original article Hit count: 451

Filed under:
|
|

From SP i need to get a row as as XML (Includeing all fileds.) Is there any way we can get like below.

Declare @xmlMsg varchar(4000)
select * into #tempTable from 
dbo.order for xml raw 

select @xmlMsg = 1 from #tempTable 

print '@xmlMsg' + @xmlMsg  

Row i would like to get it as XML output.

© Stack Overflow or respective owner

Related posts about stored-procedures

Related posts about Xml