SQL Server : cannot update column in table

Question

I cannot work out why my column is not being updated.

I have added a new column to an existing table as follows:

ALTER TABLE dbname..tablename 
  ADD RejectedCode [varchar](5) NULL

When I run the query below:

UPDATE dbname..tablename 
SET RejectedCode = 'OTHER',
    Notes = 'DEBUG'
WHERE RecordID = 12345

it says:

(1 row(s) affected)

I check the respective record and I can see the Notes column updated, but the new column still displays NULL and I don't get any error message.

What am I doing wrong? Many thanks for help.

Answer 1

Looks like you have trigger instead of update on your table