Ask a simple yes/no question and get a few tangent replies, damn.

Its quite simple. You have a table as follows.

CREATE TABLE Test (

ID INT IDENTITY(1,1)

Name VARCHAR(100)

)

INSERT INTO Test (Name) VALUES ('Tom')

UPDATE Test SET Name = 'Tom' WHERE ID = 1

Does the update statement overwrite Tom even though Tom is already the value.