Interesting question and even more interesting answer, thanks Steve 🙂
The answer "The row is not updated and no error is returned."
should rather be listed as: "No row is not updated and no error is returned."
and would apply for this situation:
CREATE TABLE [dbo].[Employees](
[EmployeeID] [int] IDENTITY(1,1) NOT NULL,
[LastName] [nvarchar](20) NULL,
[HireDate] [datetime] NULL);
VALUES ('Steve', '20160202'), ('George', '20150228');
select * from [dbo].[Employees];
CREATE VIEW NewEmployees2
WHERE HireDate > '20160101'
WITH CHECK OPTION;
SET HireDate = '20150330'
WHERE EmployeeID = 2;
DROP VIEW [dbo].[NewEmployees2];
DROP TABLE [dbo].[Employees];