Syntax for UPDATE statement with parameters?

Question

Here's the working SQL Statement:

DECLARE @LayOdds DEC = 1.5
DECLARE @Umarketiduselectionid VARCHAR(50) = '1.12677402748783'

UPDATE [dbo].[Fixtures]
SET [Fixtures].[Percent] = [Fixtures].[BackOdds] / @LayOdds * 100 - 100
WHERE [Fixtures].[MarketSelectionId] = @Umarketiduselectionid

Here's my incorrect C# Statement:

string sql = "Update Fixtures SET Percent = BackOdds / @LayOdds * 100 - 100 WHERE MarketSelectionId = @Umarketiduselectionid";

using (var cmd = new SqlCommand(sql, con))
{
    cmd.Parameters.Add("@LayOdds", SqlDbType.Decimal).Value = layOdds;
    cmd.Parameters.Add("@Umarketiduselectionid", SqlDbType.VarChar).Value = umarketiduselectionid;
    con.Open();
    cmd.ExecuteNonQuery();
}

Getting Incorrect syntax near the keyword 'Percent'.

Thank you Jim - worked beautifully. Had a feeling when I defined that column as 'Percent' that it might conflict somewhere along the line lool. Spotted that and edited just as you were commenting Gordon. — user6063812, Sep 19 '16 at 00:02
What's the protocol here guys? Shall I answer it with your resolution, Jim, or delete the question? — user6063812, Sep 19 '16 at 00:06
Possible duplicate of [Getting syntax error in INSERT INTO statement](http://stackoverflow.com/questions/37640847/getting-syntax-error-in-insert-into-statement) — Salah Akbari, Sep 19 '16 at 18:01

score 1 · Answer 1 · answered Sep 19 '16 at 17:48

1

Answer provided kindly by Jim Hewitt above. Many thanks.

Percent is a reserved word. Try [Percent].

answered Sep 19 '16 at 17:48

user6063812

191
2
15

Syntax for UPDATE statement with parameters?

1 Answers1