Well a trigger is verry suitable for this purpose
here is a good article that covers the subject on how to use them in the by
you described situation
http://www.developerfusion.co.uk/show/2413/1/
a trigger is not faster or slower as a SP ,, in a mather of fact i was
tought that in fact a trigger is a event driven proc , this is why they are
so handy they can be "triggered" at certain events that occur on your table
( inserting , deleting , modifying data )
regrds
Michel Posseth [MCP]
"Chris" <no@spam.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...
Agnes wrote: I got two same tables (invoice, invoice_history)
When user insert the record, (i will save a copy in the table
invoice_history)
when user amend the record, (i iwll save the updated record in the table
invoice_history_too)
Now, I am worry that I don't know how to do that by trigger rule.
If is use SP to do, Will it make the system (vb.net) too slow,
I am newbie in trigger rule , and don't know how to design,
Can anyone be kind to give me some idea ? Thanks in advance.
using a sproc will not slow down the system. In most cases a sproc will
speed things up.