if Updated my table i want change status

• Arjun123

  SSC-Addicted

  Points: 468

  More actions

  January 28, 2013 at 10:14 pm

  #273517

  Hi,

  I was updated my table ,then i want change status_flg in updated table

  is it possiable ?

  help me ,,

  Regards

  Arjun

• Stupeo

  Hall of Fame

  Points: 3067

  More actions

  January 29, 2013 at 12:57 am

  #1581917

  What you need is a TRIGGER:

  http://msdn.microsoft.com/en-us/library/ms189799(v=sql.105).aspx

  If you post your table schema, I will put together a sample trigger for you.

  Matt