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