UPDATE field to same value?

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'

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).

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

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.

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