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
– user6063812, Commented Sep 19, 2016 at 0:02
What's the protocol here guys? Shall I answer it with your resolution, Jim, or delete the question? — user6063812
– user6063812, Commented Sep 19, 2016 at 0:06
Possible duplicate of Getting syntax error in INSERT INTO statement — Salah Akbari
– Salah Akbari, Commented Sep 19, 2016 at 18:01

user6063812 · Accepted Answer · 2016-09-19 17:48:17Z

1

Answer provided kindly by Jim Hewitt above. Many thanks.

Percent is a reserved word. Try [Percent].

answered Sep 19, 2016 at 17:48

user6063812

2013 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

Syntax for UPDATE statement with parameters?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related