UPDATE field to same value?

[Phenix]

In MS SQL Server 2000:
If I perform an UPDATE on a field that already has the value I am setting it to in the UPDATE statement, will the value be set again and will triggers refire?

Or will only the fields where there needs to be a change be affected?

For instance; lets say I have:
Table1
Id Parameter
1 A
2 B
3 A

UPDATE Table1 SET Parameter = 'B'

instead of

UPDATE Table1 SET Parameter = 'B' WHERE Parameter != 'B'

[brucevde]

Each record, including Id 2, will be affected by the first Update statement. Either way the trigger fires only once (triggers do not fire for each record being updated).

[mendhak]

It depends upon the trigger. Is it an INSERT trigger, UPDATE trigger or what?

[Phenix]

MySQL says that MySQL only UPDATEs the values that need changing, so I thought I'd ask for MS SQL Server.

I had a brilliant idea this morning...to RTFM. But I didn't have time today.

I didn't write the triggers or stored procedures (and I've never written any), so I'm not familiar with them. But from what I could gather (when I looked at them about a month ago), there are both INSERT and UPDATE as well as changes to a different table which also has its own triggers and SP's. I'll take a closer look when I get the chance.

[sw_is_great]

That update statement will affect all the rows......
so the trigger for update will be fired.