Trigger for inserting record in another table

• mimo82

  Grasshopper

  Points: 16

  More actions

  January 26, 2009 at 5:50 am

  #204536

  Dear all

  I need a solution for this

  I have two tables one is Current Emp [ T1 ] and the other is Previous emp [ T2 ] , So I need a trigger that will delete the record from the T1 table and inserted to the T2 table ?

  >> I hope it's clear <<

• Michael Earl-395764

  SSC Guru

  Points: 53873

  More actions

  January 26, 2009 at 6:08 am

  #932548

  Please don't cross-post.

  http://www.sqlservercentral.com/Forums/Topic643364-149-1.aspx