sql query error -Incorrect syntax near WHERE : Automation API

[omayer]

what am i missing here -trying to insert data in existing row

cmdScnDesc = new SqlCommand("INSERT INTO PlacementRunResults(ScenarioDescr) VALUES (@_scenarioDescr) WHERE scenarioid LIKE @_scenarioid",dbConnection._conn);
Thank you in Advance
Beginner

[artur_gadomski]

You need update statement. I think it should look like that, but you may want to google it to make sure the correct syntax.

Code: Select all

UPDATE TABLE PlacementRunResults
SET ScenarioDescr = @_scenarioDescr
WHERE scenarioid LIKE @_scenarioid

[omayer]

It works, Thank you so much for your help