I want a nice example of an instead of update trigger on a view

• Shaun McGuile

  SSCarpal Tunnel

  Points: 4141

  More actions

  February 4, 2009 at 9:52 am

  #127284

  Hi,

  does anyone have a nice example of an instead of update trigger on a view?

  e.g.

  it kicks in when this is executed

  UPDATE VIEW_X

  SET COLUMN_A = 1,

  COLUMN_B = 2

  WHERE COLUMN_C = 3

  I want to know how to get the values from the above and update TableX which has the columns in but is part of VIEW_X

  How do I use the 'INSERTED' and 'DELETED' tables?

  Hiding under a desk from SSIS Implemenation Work :crazy:

• Vijaya Kadiyala

  SSCrazy Eights

  Points: 9149

  More actions

  February 4, 2009 at 10:15 am

  #938164

  Hi

  Check out the below which gives you detailed explanation of INSTEAD OF TRIGGER on View.

  http://msdn.microsoft.com/en-us/magazine/cc164032.aspx

  Thanks -- Vj

  http://dotnetvj.blogspot.com

  Thanks -- Vijaya Kadiyala
  www.dotnetvj.com
  SQL Server Articles For Beginers