Post
Ask Question

Create Insert Trigger

  1. Create trigger emp on YorTableName  
  2. for  
  3. insert  
  4. as   
  5. begin  
  6. Declare @InsertparamName varchar(20)  
  7.   //storing inserted value into varriable
  8. select @InsertparamName =i.Namefrom inserted i;  
  9.   //inserting above first table records into second table
  10. insert into secondTable(City)values(@InsertparamName )  
  11. End