Updatable Columns in Update Trigger

[Vishal Patel]

Hi everyone,

It will be great help to me, if some body come up with solution about updatable columns in Update Triggers.

Consider the following case data:

I have three tables a, b and c. Table ‘a’ have certain fields, on update of that fields I need to update table ‘b’. And table ‘b’ in turn processes data of table ‘c’. This refers every single Insert, Update or Delete in table ‘b’ scans table ‘c’ entirely. No, my problem is certain fields in table ‘a’ gets updated frequently but at that time I need not have to update table ‘b’. As if now, in current situation I’m not able to provide updated columns list in trigger as we are able to do in ‘Oracle’. This practical problem has caused some performance issue.

At this point of time I’m also not able to split table ‘a’ that can cause my reporting portion badly.

Thanks in advance.

Regards,
Vishal