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