saving the FOR XML AUTO results to variable in SQL
Posted
by petergo
on Stack Overflow
See other posts from Stack Overflow
or by petergo
Published on 2009-05-27T04:55:32Z
Indexed on
2010/06/18
13:23 UTC
Read the original article
Hit count: 192
select @[email protected]('*')
for xml raw,type
Above statement will generate following alert:
Msg 6819, Level 16, State 3, Line 2
The FOR XML clause is not allowed in a ASSIGNMENT statement.
© Stack Overflow or respective owner