how to get an xml in a variable

Posted by sam on Stack Overflow See other posts from Stack Overflow or by sam
Published on 2010-03-08T15:45:42Z Indexed on 2010/03/08 16:21 UTC
Read the original article Hit count: 165

Filed under:

I have a stored procedure that will return xml. I have delared a variable of type xml and trying to execute the following code

 declare @v xml
 set @v = execute get_xml @id, 33

whereas id is returned by another query. now it keeps compalinng about the following error Incorrect syntax near the keyword 'execute'.

© Stack Overflow or respective owner

Related posts about sql-server-2005