create table MyTable( id int identity , namn varchar(20) , primary key(id) ) insert mytable values ('Peter') insert mytable values ('Johanna') insert mytable values ('Ilsa') insert mytable values ('Molgan') insert mytable values ('Joe') select * from mytable create table MyTable_Log ( action varchar(20), id int, OldName varchar(20), DateChanged datetime, primary key(id) ) delete MyTable OUTPUT 'Deleted', Deleted.*, getdate() into MyTable_Log where id = 2 update MyTable Set Namn = 'Görgen' OUTPUT 'Updated', DELETED.*, getdate() into MyTable_Log where id = 3 select * from MyTable_Log |
Just Code >