Can I Use Order by to sort Stored Procedure result

问题:

Simply, I have this SQL statment:

EXEC xp_cmdshell 'tasklist' 

can we order or filter the results by using order by or where?

Thanks,

回答1:

You need to output the results into a temporary table first. This should show you how to do it

Insert results of a stored procedure into a temporary table

回答2:

I checked jamietre link, and this is the complete answer:

Create table  #MyTempTable
(output varchar(max))

INSERT INTO #MyTempTable
EXEC xp_cmdshell 'tasklist' 

select * from #MyTempTable where output like 'ie%' order by output 

Thanks for all...

回答3:

not directly. You can insert exec into a temp table or table variable and then sort that though