Updating Select columns in a View

• Pmeinhardt

  Grasshopper

  Points: 20

  More actions

  January 24, 2003 at 9:22 am

  #101360

  I have a view to one table in SQL Server 7.0

  I am developing in SQL Server 2000.

  The view has two columns which are keys on the main table. I do not want the user to be

  able to update the two columns which are keys but they can update the other columns in the view.

  The users are connecting to the view with Access 2000. I have a last_updated_date field

  that I would like to be updated automatically

  when they make changes to the updateable columns on the view. I know triggers are expensive but there are about 166 thousand records on the database.

  Please give me some advise on the best way to

  approach this.

  Thanks

• nmoore

  SSCrazy

  Points: 2414

  More actions

  January 24, 2003 at 10:01 am

  #447168

  Use getdate() function on an update trigger for the table to populate your lastupdated field and don't make the 2 columns visible in your view.

  Nigel Moore
  ======================