Hello
I run code bellow.
declare @SQLstring nvarchar(max) , @ExeCommand nvarchar(max),@OutString nvarchar(max)
set @SQLstring = ' EXEC [dbo].[xmlGenerate] 20, 100001, 1 '
EXEC sp_executesql @SQLstring , N'@OutString nvarchar(max) output', @OutString=@ExeCommand output
select @ExeCommand
select @OutString
I can't see the out put XMl, when I " select @ExeCommand " or select "@OutString[/code]"
it returns NUll.