Not Trigger few Columns

Question

Viewing 2 posts - 16 through 16 (of 16 total)

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

GSquared SSC Guru Points: 260824 More actions · Answer 1

If you don't need to audit col2 and col3, why include them in the select statement in the trigger? Why include them in the audit table?

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

RJ-476420 SSCarpal Tunnel Points: 4806 More actions · Answer 2

Well! good point. I will have to check with business to see if this is required for any other purposes.

Thanks