Create a SQL Trigger

T-SQL Trigger on 1 table ## Deliverables I have 2 tables table1 and table1_archive. I ahve a field in table1 called field1 and whenever 1) A record is inserted into table1 with field1 set as 100 then a copy of he entire row must be inserted into table1_archive 2) An existing record is updated and the field1 set as 100 then a copy of he entire row must be inserted into table1_archive 3) Im not worried about duplicates in table1_archive 4) there are 3 extra fileds in table1_archive , id (identiy) ArchivedBy = user() ArchiveDate = getdate() I will send the script to create the table, there are more than 20 columns thats it