sql server - View with a read only column -

Hi I would like to design a query where no column is updateable, but yes everyone else

How can I do this?

Regards

Well, I suppose you have any INSTEAD of triggers on the scene There is a need to use so that the base table is not directly updated.

Here is the article explained to them

Another example sample code is shown below

Sample (of course, It needs to be modified to fit it.)

  To update as an updater, create tr_employees_U on the employee (last name) BEGIN RAISERROR ('last name can not be changed' , 16, 1) Rollback Tran Return Back  

Use either trigger:

1) Error that column is updated Try to specify

2) Do not update the column

Then you should be set.