• UPDATE [dbo].[tbProducts] set [ProductCost] = @1 WHERE [ProductID]=@2

    For my test using 2008 R2 I actually got the values used in the update statement and not variables. I got:

    update dbo.tbProducts Set ProductCost = 2750 where ProductID = 1

    Is this a 2008 vs R2 thing?

    Cheers