RE:

• Jeyanthan

  Valued Member

  Points: 65

  More actions

  January 12, 2006 at 2:21 am

  #170548

  Hi,

  I need a guid line to write trigger in T SQL Server 2000 in such situation like using if conditions.

  e.g:

  if a employee details is updated by an  operator..

   

  i need the trigger to insert the opartor & the employee details in to some other table.

• peterhe

  SSChampion

  Points: 11469

  More actions

  January 12, 2006 at 7:04 am

  #614329

  In your update trigger, add the following:

  IF UPDATE(EmployeeColumn)

  BEGIN

   

  --Your code here

  END

   

• Jeyanthan

  Valued Member

  Points: 65

  More actions

  January 12, 2006 at 8:40 pm

  #614527

  Thanks Peter ,let me try