Store result of xp_cmdshell to variable

[NathanGriffiths]

Hi,

I want to put the result of running an xp_cmdshell command into a local variable. Is this possible?

e.g.

execute master..xp_cmdshell 'dir /b d:\Client\Updates\2003\Apr_2003\Data\*19094*.*'

returns;

MRN19094X20030329.csv

Can I somehow store this to a local varchar variable?

thanks in advance,

Nathan

 

[JamesLean]

I don't think you can put it in a variable but you can insert it into a temp table:

CREATE TABLE #cmd (txt varchar(1000))

INSERT #cmd
EXEC master..xp_cmdshell 'dir /b d:\Client\Updates\2003\Apr_2003\Data\*19094*.*'

--James