Neela Khatri (3/12/2012)

---

...
In the options available to be checked, results was spelled wrong twice ...

Hugo Kornelis (3/12/2012)

---

...
And if the view includes the WITH CHECK option, those people would also be unable to change active members to non-active members.

tilew-948340 (3/12/2012)

---

I am not sure to understand perfectly the WITH CHECK option.

CREATE VIEW SalesPpl
AS
  SELECT EmpNo, Name, Salary, Department
  FROM Personnel
  WHERE Department IN ('Sales', 'SalesBackOffice');

SQLRNNR (3/13/2012)

---

Got any more like this Ron?

Hugo Kornelis (3/13/2012)

---

...
The view above allows people to add personnel into the Marketing department, or to update a row to transfer someone from Sales to Accounting. The WITH CHECK option prevents that, while still allowing users to update a row to transfer people between Sales and SalesBackOffice.