Re: insert different from union?
From: Paul Vernon <paul.vernon_at_ukk.ibmm.comm>
Date: Tue, 27 Jan 2004 20:16:54 -0000
Message-ID: <bv6h5v$1bpm$1_at_gazette.almaden.ibm.com>
Date: Tue, 27 Jan 2004 20:16:54 -0000
Message-ID: <bv6h5v$1bpm$1_at_gazette.almaden.ibm.com>
"Bob Badour" <bbadour_at_golden.net> wrote in message
news:GJudnaoYs557MYvdRVn-sA_at_golden.net...
[snip]
> Triggers do not operate on 'rows'; although, I am sure some idiotic
> implementation or another does. Triggers operate on sets of tuples or
rows.
I'm guessing that more SQL systems support triggers at a row level or at both row and statement levels than at only statement level. The SQL standard certainly allows both row and statement level triggers.
> Keys have nothing to do with an update trigger, because an update can
alter
> all of the keys.
That's useful.
Regards
Paul Vernon
Business Intelligence, IBM Global Services
Received on Tue Jan 27 2004 - 21:16:54 CET