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 n开发者_运维技巧o update is really needed?
Is actually smart enough to recognize that the update is required. There are many more factors at play, a trivial example being triggers.
精彩评论