Badly titled OP.
If you have a statement that gives the same end result no matter how many times it is run, what is it called? (I'm sure there is a word for it).
e.g.
Update fred
set age = 10
This is unlike the following statement which will have a different result dependant on the number of times it is run:
Update fred
set age = age + 10
Thanks