When we use SQL Server 2008 to write SQL statement using the keyword update, it was colored in blue:
But when we write the same SQL in SQL Server 2014, it's in magenta:
And as we know, the magenta color in the SQL Server is normally not for keywords, but for built-int functions, or datepart (and some others):
(in the example above, Datename and getdate are built-in functions while day and week are datepart)
But the select, create, insert, and delete keywords are all consistently blue in the SQL Server:
What's the reason behind this change (is update a function now)? Is there any way to change the update color back to blue in SQL Server 2014?