asked
Save PowerShell variables Within xp_cmdshell
Does anyone know if it is possible to save POWERSHELL variables when using xp_cmdshell when calling powershell code? The code below returns NULL when run from within SSMS but it should return HELLO as that is the variable I am storing in $test declare @sql as varchar(255) set @sql = 'powershell.exe -c "$test = ''hello'' $test"' EXEC xp_cmdshell @sql
I figured it out. You need to put it on the same line and separate with a ";" declare @sql as varchar(255) set @sql = 'powershell.exe -c "$test = ''hello''; $test"' EXEC xp_cmdshell @sql
17 People are following this question.
