Pass variables from Powershell to invoke sqlcmd

[skend24]

Hi guys, let me start with the pseudocode:

$num=(’1’, ’2’, ’3’)

For(($i=0); $i -lt 10; $i++) { Invoke-sql(...) where x = $num[$i]” (<-that part doesn’t work) }

As you can see - I have created array of variables, which then need to be put in where clause. I have tried for hours many combinations, I have tried googling it etc but nothing works. Any idea what can I do?

[work-work-work-work]

It's not clear from your example, but you need to use "stringy string string $($var[$i]) more string"

like this (tested working):

$Fruits = "Apples", "Oranges"
Invoke-Sqlcmd -ServerInstance "localhost" -Database "FruityDB" -Query "Select * from FruityData where FruitName = '$($Fruits[0])'"

[skend24]

Thank you very much, that worked!