SQL Query not accepting variable [duplicate]

Question

I am trying to pass a variable into a SQL update statement to update a table column. I run the following commands and do not receive any errors. However, the table column was not updated.

$SQLserver = 'servername'
$Database = 'databasename'

$variable = (Get-Content -path \\share\test\testfile.json | ConvertFrom-Json)

$vm = Invoke-SQLCMD -ServerInstance $SQLServer -Database $Database -Query "Update (tablename) set (columnname) = 1 where vmid IN ('$variable.attribute')"

I see that all the data is being passed into the variable. But, the update statement is not updating my column. Also, I do not receive any error messages when running my code.

Simple variables expand in double quotes. To access properties of a variable, enclose in a subexpression $(). Check the duplicate. — Doug Maurer
– Doug Maurer, Commented Dec 11, 2022 at 0:48

Andres Ospina · Accepted Answer · 2022-12-11 01:03:51Z

-1

you were too close, only "$" missing, here's the correct code

$SQLserver = 'servername'
$Database = 'databasename'

$variable = (Get-Content -path \\share\test\testfile.json | ConvertFrom-Json)

$vm = Invoke-SQLCMD -ServerInstance $SQLServer -Database $Database -   Query "Update $tablename set $columnname = 1 where vmid IN ('$variable.vmid')"

answered Dec 11, 2022 at 1:03

Andres Ospina

1581 gold badge2 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Doug Maurer Over a year ago

You should test before you post an answer. This is not a valid answer currently.

Collectives™ on Stack Overflow

SQL Query not accepting variable [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related