Is it possible to Insert, Update and delete rows, from the underlying tblEmployees table, using view vWEmployeesDataExceptSalary?

Yes & No, depending on the number of base tables, the VIEW is created upon, and the number of base tables affected by the UPDATE statement. 


1. A View is based on a single base table, then the UPDATE suceeds and works as expected.
2. A View is based on more than one base table, and if the UPDATE affects multiple base tables, the update is not allowed and the statement terminates with an error.
3. A View is based on more than one base table, and if the UPDATE affects only one base table, the UPDATE succeeds(but not as expected always)


 If a view is based on multiple tables, and if you update the view, it may not update the underlying base tables correctly. To correctly update a view, that is based on multiple table, INSTEAD OF triggers are used.