Trigger for some deleted info

Question

Post reply

Trigger for some deleted info

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 739541 More actions · Answer 1

create trigger mytrig on tableA for update, delete as

insert mytable

select id, name, etc

from deleted

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

storiale SSC Rookie Points: 40 More actions · Answer 2

I don't know if my last post, posted. So I'll say it again. You're a genius.

One more question: What if I also wanted it to log records that were updated and put them in the same table? I tried "as deleted, updated" but that didn't work.

5409045121009-7368 SSCoach Points: 15740 More actions · Answer 3

See Steve Jones example above, create an update trigger and the updated contents should be in the inserted table. Also look at the update(Col) function.