带参数的UPDATE语句语法？

Question

下面是正在运行的SQL语句：

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

下面是我不正确的C#语句：

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();
}

在关键字“%”附近获取不正确的语法。

Answer 1

以上回答由Jim Hewitt亲切提供。非常感谢。

Percent是保留字。试试Percent。