title: Restrict update Column
body: <p>Is it possible to restrict updating a column in SQL without using a trigger ? If so how ? (need the query)</p>
  
  <hr>
  
  <p>PS:</p>
  
  <p>I mean, I have a table</p>
  
  <pre><code>CREATE TABLE MYBUDGET.tbl_Income
  (
      [IncomeID]          INT             NOT NULL IDENTITY(1,1),
      [IncomeCatID]       INT             NOT NULL,
      [IncomeAmnt]        MONEY           NOT NULL,
      [IncomeCurrencyID]  INT             NOT NULL,
      [ExchangeRateID]    INT             NOT NULL,
      [IncomeAmnt_LKR]    MONEY           NOT NULL,
      [AddedOn]           DATETIME        NOT NULL,
      [Remark]            VARCHAR(250),
  )
  </code></pre>
  
  <p>I need to allow users to update only <code>[ExchangeRateID]</code> and <code>[IncomeAmnt_LKR]</code> fields. All other fields can not be updated. only insert.</p>