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
sql query error -Incorrect syntax near WHERE
- artur_gadomski
- Posts: 207
- Joined: Mon Jul 19, 2010 6:55 am
- Location: Copenhagen, Denmark
- Contact:
Re: sql query error -Incorrect syntax near WHERE
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