SQL SERVER – Difference Between UPDATE and UPDATE() | Journey to SQL Authority with Pinal Dave

What is the difference between UPDATE and UPDATE()? UPDATE is syntax used to update the database tables or database views. USE AdventureWorks ; GO UPDATE Production.Product SET ListPrice = ListPrice * 2; GO UPDATE() is used in triggers to check update/insert to the database tables or database views. Returns a Boolean value that indicates whether… Continue Reading...

Source: SQL SERVER – Difference Between UPDATE and UPDATE() | Journey to SQL Authority with Pinal Dave