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'