开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜