Hi,

I've pondered on the problem for some time. All I was able to come up
with was to add an extra insert at the end of the batch, with a
"special" value in one of the fields, which would be recognized by the
trigger and would cause it to execute its code (otherwise the trigger
just exists immediately after being fired).
That's not a very elegant solution, though, but better than nothing.

cheers
Tomasz

On 2012-02-02 14:05, nathanelrick wrote:
> Hello,
>
> when i execute several insert (or update or delete), is it possible to create a trigger that will be raise not on each insert/update/delete but at the end of these "bulk" inserts ? i can off course call the stored procedure from the program but for good database integrity i prefer that the database do it itself ... i thing that their is no possibilities to do so but in case ....
>
>


--
__--==============================--__
__--== Tomasz Tyrakowski ==--__
__--== SOL-SYSTEM ==--__
__--== http://www.sol-system.pl ==--__
__--==============================--__