CODEWITHSUNDEEP
sqlsql-servert-sqlsql-update
Andrey
Andrey

Reputation: 21295

T-SQL conditional UPDATE

If I have an update statement like this:

UPDATE Message 
   SET Subject = Subject

...will SQL Server actually perform an update or is it smart enough to recognize that no update is really needed?

Upvotes: 0

Views: 508

Answers (1)

Remus Rusanu
Remus Rusanu

Reputation: 294437

Is actually smart enough to recognize that the update is required. There are many more factors at play, a trivial example being triggers.

Upvotes: 2

Related Questions